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 |
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! |
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 |
All times are GMT +1. The time now is 06:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com