View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
WillyV WillyV is offline
external usenet poster
 
Posts: 1
Default Can't Stop Date Values from Changing to Formulas

I have a very old spreadsheet,which appears to have been converted from Lotus
at some point, which will not allow me to type a date in a cell without it
automatically converting it to a formula after I hit ENTER. This obviously
results in a value which I don't want to see. I can't seem to delete the
equal sign from any of the cells with dates in them. I delete it, hit ENTER,
then it appears again.

It only happens on the one sheet in question and appears to be related to
how it was converted from Lotus. Any ideas how to turn off this property? I
validated that the sheet is saved in Microsoft Excel format.

Willy V