View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DJaded DJaded is offline
external usenet poster
 
Posts: 5
Default Formulas to Values

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.