Why won't cell accept any formula ?
 

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 does
not behaves as a formula.
I.e. the cell simple remains as "=A1" instead of taking the value in
"A1"


--
dewsbury
------------------------------------------------------------------------
dewsbury's Profile: http://www.excelforum.com/member.php...o&userid=16084
View this thread: http://www.excelforum.com/showthread...hreadid=484810

Why won't cell accept any formula ?
 

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

--
Kind regards,

Niek Otten

"dewsbury" wrote in
message ...

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 does
not behaves as a formula.
I.e. the cell simple remains as "=A1" instead of taking the value in
"A1"


--
dewsbury
------------------------------------------------------------------------
dewsbury's Profile:
http://www.excelforum.com/member.php...o&userid=16084
View this thread: http://www.excelforum.com/showthread...hreadid=484810

Why won't cell accept any formula ?
 

Thanks!

V. helpful


--
dewsbury
------------------------------------------------------------------------
dewsbury's Profile: http://www.excelforum.com/member.php...o&userid=16084
View this thread: http://www.excelforum.com/showthread...hreadid=484810