Sounds like some cell are formatted Text; you want them all to be General
when you type the formulas. Let us know if this works for you
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"dbsocal" wrote in message
...
Hi,
In one of my worksheets, some cells are overwriting the equations with the
equation value - but this is not happening in all of the cells.
For instance, in cell A1, when I type "+12000/12", the cell contents
become
"1000".
In cell, B1, when I type "+12000/12", the cell contents become
"=+12000/12".
However, in cell A1, when I type "=12000/12", the cell contents are
"=12000/12".
Why is this happening and how do I fix it? This only seems to happen in
one
specific workbook (and, unfortunately, there is too much data and
formatting
to re-create the file).
Any thoughts would be appreciated!
--
Thanks