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 How do I enter a date without using slashes or dashes?

Look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Sue Miller" <Sue wrote in message ...
|I want to be able to enter, for example, "030107" and have the cell formatted
| so I get 03/01/07.