Formulas displaying as text. Show Formulas NOT turned on. Fast fix for entire column?

[blbat]

I've got a bunch of formulas displaying as text, instead of showing the value of the formula- "Show Formulas" is NOT turned on!

I know the fix for a single cell is to click into the cell and hit the "Enter" key. is there a fix for an entire column, or range of cells?

thx!

 

[joeu2004]

First, be sure the cell format for all cells is not Text. It should be General, Number, Currency or some other numeric format.

Then, select the cells, press ctrl+h (Find and Replace), click Options and be sure that Look In Formulas is select, and click Options again to return to the Find and Replace dialog. Click Find, and enter "=" without quotes. Click Replace, and enter "=" without quotes. Then click Replace All.

 

[blbat]

!! Thank you very much...I knew there had to be a fast way to do this!