Thread: date formatting in excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
  
Posts: 3,268
Default date formatting in excel
Not possible without VBA (macro)


http://www.cpearson.com/excel/DateTimeEntry.htm



--
Regards,

Peo Sjoblom



"kwood525" wrote in message
...
I am trying to set up my date formatting so that I do not have to type in
the
forward slashes when I input the date. I would like to be able to just
type
in the date numbers: 083007

and have it automatically convert to: 08/30/07 when entered.

any tips?


Reply With QuoteReply With Quote