View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Macnutt Macnutt is offline
external usenet poster
 
Posts: 1
Default Weird format to formula transition excel 2003

When entering a date into a cell even after changing the format to Date
format, excel is viewing my entry as a formula.

Here's my process:
I choose format cells, date, okay.
enter 10/19/06
display shows 1/0/1900

cell display shows =10/19/6

I've chosen multiple date formats with the same result.

Ideas?