Thread: date formatting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gracie
 
Posts: n/a
Default date formatting

I selected a cell to be formatted as a date (MS example 03/14/01)

When I key 120199 in that cell it displays in as 02/02/29......Why?
I even went into the Control Panel then Regional Settings for Date.