Thread: Date Formating
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mel Mel is offline
external usenet poster
 
Posts: 74
Default Date Formating

One of our users has an excle worksheet with three date columns all fomatted
as date. Formattig being used is 2/22/07 for example. However for all three
columns when you type in the required date of say 2/22/07 and hit enter, it
defaults to 01/00/00. It defaults to 01/00/00 in each cell for these three
date columns. How can I fix this?