Do you mean that when you look in the Formula Bar you see a value, not a
formula?
Cell, of course, normally show values
If you tell us more we might be able to help
Any change you have a lurking macro?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"DJaded" wrote in message
...
What might cause, and how can I stop formulas from being automatically
converted to values? When I enter a formula into a cell, it is immediately
stored as the RESULT, not the actual formula. This is not consistent, even
with formulas that are "COPY-DOWN" [<Ctrl-D] in the same column. Some
formulas remain and some convert to their resulting value.