I am a heavy excel user and occassionally I will run into issues where my
formulas are not recognized. When I type in the formula, the text string that
I entered is returned. This does not happen all the time but definitely
enough to frustrate.

Assuming you haven't formgotten an = sign, this only happens when the cell
you are entering data into is formatted as text. If you insert a column to
the right of another column, then it will take on the formatting of the
column to its left, so if text to the left thne your new column is text.

Just format the cell(s) as general, hit F2 and Enter and your formula will
be fine.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



"PB" wrote in message
...
I am a heavy excel user and occassionally I will run into issues where my
formulas are not recognized. When I type in the formula, the text string
that
I entered is returned. This does not happen all the time but definitely
enough to frustrate.

It could also happen if Formulas is checked at Tools|Options|View , but
that would impact all cells containing formulas.

Jerry

Ken Wright wrote:

Assuming you haven't formgotten an = sign, this only happens when the cell
you are entering data into is formatted as text. If you insert a column to
the right of another column, then it will take on the formatting of the
column to its left, so if text to the left thne your new column is text.

Just format the cell(s) as general, hit F2 and Enter and your formula will
be fine.