Why won't cell accept any formula ?

D

dewsbury

I am sure this is simple.
I have inserted a new column into a sheet.

However when I insert any formula (e.g. =A1) into the new sheet it doe
not behaves as a formula.
I.e. the cell simple remains as "=A1" instead of taking the value i
"A1
 
N

Niek Otten

Your new column is formatted as text.
Format as general and re-enter the formula (F2, ENTER)
 
Top