Hi,

Unfortunately, all of the cells are formatted as "number", so this won't work.

Any other thoughts?
--
Thanks


"Bernard Liengme" wrote:

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