software

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!
--
Thank You,
Shimmy

See

cpearson.com/excel/DateTimeEntry.htm

In article gt;,
Shimmy gt; wrote:

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

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

nwexcelsolutions.comquot;Shimmyquot; gt; wrote in message
...
gt; How can I enter a date (mmddyyyy) without having to enter the dashes?
gt; Different numbers come up when I try to type the date without dashes or
gt; slashes? Please Help!
gt; --
gt; Thank You,
gt; Shimmy