View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Clark Clark is offline
external usenet poster
 
Posts: 49
Default Date not displaying correctly

Microsoft Excel 2007

I have a column whose fields are defined as 'date'. When I type the date
into the field it will not display the correct date. Example:

I type in '9/29/08' and the field displays '1-Jan-00' instead of
'29-Sep-08'. In the formula bar it reads what i typed...'=9/29/08'

Any suggestions as to why this is happening??