Thread: date format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
andresg1975 andresg1975 is offline
external usenet poster
 
Posts: 60
Default date format

when i enter 3/15/2005, excel displays 1/1/1904
and the cell contains =3/15/2005

how can i make this work so that it shows my real date, which is 3/15/2005

thanks a lot