Date Format

[Guest]

How can I enter a date (mmddyyyy) without having to enter the dashes?
Different numbers come up when I try to type the date without dashes or
slashes? Please Help!

 

[JE McGimpsey]

See

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

 

[Peo Sjoblom]

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

nothing built in since there is no way excel could guess that 12142006 is a
date as opposed to the number 12,142,006.00 But the above link will give you
a solution


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com