View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kwood525 kwood525 is offline
external usenet poster
 
Posts: 3
Default date formatting in excel

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?