General

Importing text--cell text limit?
I'm importing text via the wizard. Some strings are greater than 1027 characters in length. When the strings exceed 1027, they are truncated. Is there a way to modify the cells to allow longer strings? ... 2 Jul 2008 16:01

Need a macro to delete rows
I need to find the first data occurance in column D and delete all rows above it except rows 1 and 2. ... 2 Jul 2008 19:07

Convert Pivot to Table w Formulas
In Excel2007, I want to convert a pivot table to regular table with formulas. Currnetly I have to copy the pivot and paste special values and manually add back my formulas, ex =SUM. Is there a more efficent way of doing this?The reason I do this is that once I have my pivot data, I want to change some of the data ... 2 Jul 2008 12:56

whole number error?
When I enter a number higher than 155 into a particular cell, I receive a message "must be a whole number", little message window with an X through a red circle. Don't know if its a custom message created by previous user or an excell error? How can I fix? ... 2 Jul 2008 13:57

Formula for looking up blank and/or date-filled cells- conting
Unfortnately, that returns an Value error. I think it doesn't want to multiply dates- just as a guess... "RagDyeR" wrote: Does this work for you: =IF(A1*B1>0,"No",IF(A1+B1>0,"Yes","N/A")) ? Copy down as needed. -- HTH, RD ==================================================... 3 Jul 2008 18:41

Saving in Excel
Afternoon, I'm unsure if anyone can help. I have a user that can open an excel file, then modify it, and save but they then want to make aditional modifications but after they have done them it wont allow them to save and throws up this message.... Microsoft Office Excel cannot access the file X this may be d... 4 Jul 2008 07:57

Weird Problem while Importing Data into another sheet
Hi, I Imported one sheet's (A) data into another sheet(B). I did using Data-->Import External Data-->Import Data The problem is, in one of the columns in sheet A the data are either alphabet 'C' or number '1', '2' or '3'. In the B sheet for the same coumn all the data which are numeric appears correctly but th... 2 Jul 2008 11:54

IF function - with a twist!
Please help if you can. I am using the IF function and will simplify what I need for explanation purposes: I have a value in A1 and a value in B1 and I want to display, in C1, the larger of the two. The twist is that if that value is not larger than 100, I want to display 100. Please help if you can. ... 2 Jul 2008 12:56

Bring Back DBF! The GIS Industry uses it!
Microsoft: "Historically Excel has supported many different data formats. We have determined that a number of these older formats are seldom, if ever used. We are removing support for some file types to allow us to devote more of our efforts towards the file formats that are being used." DBF 4 (dBASE IV) is ... 6 Jul 2008 12:59

highlighting
I need to highlight every other cell in a spreadsheet. I done this a while ago but am unsure how, i have 2500 lines so i am refusing to do it manually! ... 2 Jul 2008 12:56