Thread: Date Format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
C. Bailey C. Bailey is offline
external usenet poster
 
Posts: 11
Default Date Format

I suspect this question has been asked a thousand times, but I am having a
tough time googling it.

I just did a clean install of windows and office 97. When I input 03/31
into a cell and hit enter, it comes back with 01/03/1931. Prior to
rebuilding my computer, it used to come back with 03/31/2005. What setting
do I need to change to restore this (is it in windows or excel)?

Thank you,
Chris