| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert '6/23/2005' to '062305'
Can anyone suggest a way to convert a date that looks like this:
6/23/2005 to 062305 Thanks in advanced. Ken |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Convert '6/23/2005' to '062305'
One way:
MsgBox Format(Date, "mmddyy") In article , "Ken Loomis" wrote: Can anyone suggest a way to convert a date that looks like this: 6/23/2005 to 062305 Thanks in advanced. Ken |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Convert '6/23/2005' to '062305'
Thanks,
That is so much more elegant then the character at a time programming I was trying. Ken "JE McGimpsey" wrote in message ... One way: MsgBox Format(Date, "mmddyy") In article , "Ken Loomis" wrote: Can anyone suggest a way to convert a date that looks like this: 6/23/2005 to 062305 Thanks in advanced. Ken |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I have a date 51231 (2005,dec,31) -I want to change to 2005/12/31 | Excel Worksheet Functions | |||
| Is the equation: =COUNTIF B:B, <9/31/2005 AND 9/1/2005 possible? | Excel Worksheet Functions | |||
| Convert alphanumerical(eg. 12.11.2005) to date as 12-Nov-2005 in e | Excel Discussion (Misc queries) | |||
| UK Tax & NI calculator 2005/06 | Excel Worksheet Functions | |||
| chnage date from tuesday 4 January 2005 10:39.26 to 04/01/2005 | Excel Worksheet Functions | |||
Hybrid Mode
