View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hoot Hoot is offline
external usenet poster
 
Posts: 6
Default Formatt date from text

I would like to be able to enter a date numerically and have Excel formatt it
with the slashes, ie; fromatt 092207, to 09/22/07. I don't want to have to
enter the slashes just the numeric value. How do I do this?