View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mrm
 
Posts: n/a
Default one column on my excel spreadsheet will NOT format the date

Not matter which way I try to format the cells to take a date (i.e. ##/##/##)
when I enter the date needed (i.e. 061405) it comes out either 19## or 202#.