Did you ever try the "copy an empty cell and paste special method" I gave you?


Gord

On Wed, 26 Jul 2006 15:20:01 -0700, Anisette
wrote:

Hi Guys,

Have just spent last few hours trying your suggestions and battling with
Excel - but in the end I did it the hard way and went down through each cell
hitting F2 and then Enter, F2 & Enter, F2 & Enter... Arms now about to fall
off!

The issue was with the original list of numbers - on their own they looked
fine. They were supplied by another person so they might have had a
different version of Excel - maybe. It was only when I tried the IF function
that I became aware that something was amis with the original column of
numbers.

I tried copying the column of numbers into a compleletely new spreadsheet in
a new executive of Excel. I used Paste Special/Values so that none of the
formatting code was carried across - but as before it didn't work. When I
then selected these fresh numbers and tried to Format/Numbers/General -
nothing changed.

I also tried the Find & Replace with the = but it didn't work either.

I tried both the above with a smaller extract of the column of numbers to
see if a smaller range would help - but no joy.

And just to asure you - I checked my Automatic Calculation Check Box several
times and it was in the Automatic position.

Very weird.

Anyhoo, I really appreciate your help and suggestions.

Best Regards,
Ani

Gord Dibben MS Excel MVP