Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Format
Hello
Can anyone tell me how to convert the date (e.g 17-09-2007) into this format : 1 7 0 9 0 7. Thanks in advance. CS TANG |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Format
On Sep 18, 9:56 am, wrote:
Hello Can anyone tell me how to convert the date (e.g 17-09-2007) into this format : 1 7 0 9 0 7. Thanks in advance. CS TANG I see there is a space between the digits. If that is the case then: Sub abc() strTemp = "" strdate = Format(Date, "DDMMYY") For i = 1 To 6 strTemp = strTemp & Mid(strdate, i, 1) & " " Next i End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Format
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
permanent conversion of 1904 date format to 1900 date format | Excel Worksheet Functions | |||
Convert european foreign date format to US date format | Excel Worksheet Functions | |||
Convert date + time text format to date format | Excel Worksheet Functions | |||
code to convert date from TEXT format (03-02) to DATE format (200203) | Excel Programming | |||
Change a date in text format xx.xx.20xx to a recognised date format | Excel Programming |