Thread: How do I enter a date typing 040906 and have it appear 04/09/06? I
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Stover Stover is offline
external usenet poster
  
Posts: 2
Default How do I enter a date typing 040906 and have it appear 04/09/06? I
I would like to format a cell so that I can just type in the numbers in a
date and have the cell display the date with the forward slashes added
automaticly! Example type in only 040906 and have Excel display 04/09/2006
in the cell.
Reply With QuoteReply With Quote