formula remian in cell

D

Dylan @ UAFC

I have one column in work sheet were the formula shows in the
cell and will not go away

waht can i do
 
M

Mike H

Hi,

If it's a single column then it's a fair bet the cell was formatted as text
before the formula was entered. Re-format as 'general' with the cell selected
tap F2 and enter.

Mike
 
G

Gord Dibben

If other columns' formulas are OK then I would suggest you have
pre-formatted the offending column as text.

Format to General then F2 and ENTER on each cell.


Gord Dibben MS Excel MVP
 
Top