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

I needed to data entry pages and pages of dates, how can I format a dates
without typing the (/) symbol, typing this symbols really slows me down. For
example: 102006 (for october 20, 2006), I wanted this to show as 10/20/06
just by typing 102006. Why do I get 4/11/79 as the answer when using date
format (3/14/01) on the format tab menu? Please help.