Select the range. EditReplace, replace all "=" by "=". (without the quotes,
just a sort of re-entering the formulas)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"jenn" wrote in message
...
Hello, besides pressing F2 and ENTER 6000 times... is there a way to
refresh
every cell in a column at once?