How do I enter a date typing 040906 and have it appear 04/09/06? I

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Gord
Thank you very much for your quick response. I will not be frustrated now
and accept the fact that I can't format the cells like I wanted.
Stover
 
What you can do is to enter the dates into a column in the format you
wish, and then in another column a formula can convert what you type
into a proper date. At the end of data entry you can fix the values and
use them to overwrite the value you typed in.

Hope this helps.

Pete
 
Back
Top