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

http://xldynamic.com/source/xld.QDEDownload.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"chad" <pinoyako.com wrote in message ...
|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.
|