View Single Post
  #1   Report Post  
Macdad
 
Posts: n/a
Default How do I get Excel date to change from 1/1/1900?

I am entering the date (8/25/2005) in a cell that is date-formatted.
However, once entered the cell always displays 1/1/1900 (Excel's embedded
calendar start date), i.e. it doesn't display the date I entered. How do I
get it to display teh date I entered?