Discussion Locked

Excel 97 Function Problem

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Ok- it is 97 not 2000 (were a little behind) but the downloaded CC reports from Verisign which import well don't/won't calculate. I have tried format cells into everything I can think of/tried programing cells...sum is still 0, any ideas?
thanks in advance
L

4 replies

by dklippert

One thing to try is to enter the number 1 in an empty cell. Copy it.
Select all of the imported data. Go to Edit Paste Special and choose the Multiply option.
Click OK
This forces text to numeric format.

by parier

Try to save your data as TXT (Tab delimeted). This removed all teh crazy formatting from Excel, then Open Excel first, then go to File, Open, select TXT from file type and select your file, choose delimeted when prompted and choose TAB, your preview screen should now show columnized date, click FINISH and viola, you should be all set.

Hope this helps.

This discussion is closed to new replies.