Thread: date entry without typing dashes
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default date entry without typing dashes
Right-click FormatCells NumberTab Custom ##-##-## in the small window

Vaya con Dios,
Chuck, CABGx3



"Cyrus" wrote:

I want to type "121505" in a cell and it display 12-15-05. What formatting do
I use?

Thanks

Reply With QuoteReply With Quote