View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Sandy Sandy is offline
external usenet poster
 
Posts: 156
Default Date format changes to formula

What date format did you set it to....
just to make sure you are not typing in the equal sign in correct?


Macnutt wrote:
Got a weird one. I set the date format in a cell. Then if I type the date in
mm/dd/yy format it coverts to a formula. It looks like this in the cell:
01/00/00 and the formula bar show this: =10/19/6

I've tried setting all different date formats but it is still spontaneously
switching to a formula and not displaying as a date.

Ideas?