Why the suggestion to edit the formulas when OP stated

only works when I go in to each cell in my column of numbers
and hit return

I interpreted this to mean the numbers were bogus so posted the "change text
nums to real nums fix"


Gord

..
On Wed, 26 Jul 2006 14:42:30 -0500, Dave Peterson
wrote:

Choose smaller ranges (do them one at a time) and do the edit|replace stuff.



Anisette wrote:

Excel didn't like that (I'm using Excel 2000) - also Excel has stopped
working - not enough memory!
Any other ideas?

"Dave Peterson" wrote:

I'd select a single cell (so that all cells are changed)
then
Edit|replace
what: = (equal sign)
with: = (equal sign)
replace all

Maybe it'll wake xl up!

Anisette wrote:

I have a very simple problem that is frustrating me...

I have an existing column of numbers and they Format/Cells/Number/General
assigned to them.
Over to the side I have a series of IF functions, each one comparing the
value of each cell of numbers with a defined limit.
The IF function only works when I go in to each cell in my column of numbers
and hit return.

I have more than 5000 entries, so I am desperate to find a way of getting
the IF function to recognise the numbers and give a result without having to
hit Enter on every number.

I have checked Tools/Options/Calculation and Automatic is ticked. I have
set it to manual, and then set it back to Automatic just to be sure.

I have also hit F9, Ctl+F9, Ctl+Alt+F9, Ctl+Alt+Shift+F9 - but no joy.

Any ideas?

--

Dave Peterson