Thread: Date format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cathy C Cathy C is offline
external usenet poster
  
Posts: 5
Default Date format
I want to format a column of cells so that when 012208 is entered with the
numeric keypad, 01/22/2008 appears in the cell. So far, I'm getting
6/3/1933.

Thanks,
Cathy

Reply With QuoteReply With Quote