Formulas displaying in a cell

users
#1

Please ignore this note. I found the problem.

#2

Please ignore this note. I found the problem.

Please enlighten us. I'm just now having a similar problem.\
I've tryed =TEXT(b3,"###.##") and just the formula appears in the cell.
I've tried =ABS(b3) and just the formula appears in the cell.
I'm guessing there's some switch to change from displaying formula
to displaying result; however, I've no clue where to look :frowning:

#3

It finally dawned on me that the column was formatted as Text.
When that was changed to Category=All, Format=General, things
started working.

I don't know how, but there should be some way to hint to
the user what to do when a cell which looks like a formula
is not a formula.

-regards,
Larry