Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date format
hi, im sure this is a silly question, but its driving me nuts. i need to enter a string of dates in a column. i want them to appear 01/01/2001. i formated the cells with the date format, but when i type in 010101 it formates to really wierd things, like 08/12/1955. do i have to put the slashes in, or is there a way for it to do it for me? thanks -- RAPPEL ------------------------------------------------------------------------ RAPPEL's Profile: http://www.excelforum.com/member.php...o&userid=36240 View this thread: http://www.excelforum.com/showthread...hreadid=562858 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
date format
If you already have the formatting set you should only have to enter the date such as 1jul which will produce 07/01/2006. If you want any other year other than 06 you will have to enter the year also as in 1jul04 which would then give you 07/01/2004. Again depends on the way you have it formatted as to how it appears. Hope this helps. Ed -- patele ------------------------------------------------------------------------ patele's Profile: http://www.excelforum.com/member.php...o&userid=35849 View this thread: http://www.excelforum.com/showthread...hreadid=562858 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
date format
Either use the slashes or VBA code if you wish to enter 010101 as a date.
Chip Pearson has code at his site. http://www.cpearson.com/excel/DateTimeEntry.htm Gord Dibben MS Excel MVP On Wed, 19 Jul 2006 10:01:14 -0400, RAPPEL wrote: hi, im sure this is a silly question, but its driving me nuts. i need to enter a string of dates in a column. i want them to appear 01/01/2001. i formated the cells with the date format, but when i type in 010101 it formates to really wierd things, like 08/12/1955. do i have to put the slashes in, or is there a way for it to do it for me? thanks |
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) |