| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Format
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Format
See
http://cpearson.com/excel/DateTimeEntry.htm In article , Shimmy wrote: 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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Format
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 "Shimmy" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell date format doesnt change | Excel Worksheet Functions | |||
| Enforcing a date format on a cell/column | Excel Discussion (Misc queries) | |||
| Change general format to US date format | Excel Discussion (Misc queries) | |||
| Customized Date Format | Excel Worksheet Functions | |||
| Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
Linear Mode
