Formulas not calculating

[bullwinkle55423]

This is a problem that has occurred on and off for me and I am not sure why.

Sometimes when I enter a formula into a cell, the formula shows up as the text instead of the anticipated answer.

For example, if I have 9 in cell A1 and I type =A1+10 into cell B1, B1 will show =A1+10 as the answer instead of 19.

Any ideas why it sometimes works this way?

Thanks.

[Niek Otten]

In these cases, your cell was formatted as text before you entered the formula. Formatting afterwards doesn't help.
Format the cell as general or Number and RE-ENTER the formula (F2, ENTER)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"bullwinkle55423" <[email protected]> wrote in message
news:[email protected]...
|
| This is a problem that has occurred on and off for me and I am not sure
| why.
|
| Sometimes when I enter a formula into a cell, the formula shows up as
| the text instead of the anticipated answer.
|
| For example, if I have 9 in cell A1 and I type =A1+10 into cell B1, B1
| will show =A1+10 as the answer instead of 19.
|
| Any ideas why it sometimes works this way?
|
| Thanks.
|
|
| --
| bullwinkle55423
| ------------------------------------------------------------------------
| bullwinkle55423's Profile: http://www.excelforum.com/member.php...o&userid=33574
| View this thread: http://www.excelforum.com/showthread...hreadid=566140
|

[Paul B]

bullwinkle55423, is calculation set to automatic, is the cell formatted as
text?
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"bullwinkle55423"
<[email protected]> wrote in
message news:[email protected]...
>
> This is a problem that has occurred on and off for me and I am not sure
> why.
>
> Sometimes when I enter a formula into a cell, the formula shows up as
> the text instead of the anticipated answer.
>
> For example, if I have 9 in cell A1 and I type =A1+10 into cell B1, B1
> will show =A1+10 as the answer instead of 19.
>
> Any ideas why it sometimes works this way?
>
> Thanks.
>
>
> --
> bullwinkle55423
> ------------------------------------------------------------------------
> bullwinkle55423's Profile:
> http://www.excelforum.com/member.php...o&userid=33574
> View this thread: http://www.excelforum.com/showthread...hreadid=566140
>