| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.misc
|
|||
|
|||
|
Date Format
Don't think you can break the number of days/months/years like that.
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) wrote in message oups.com... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Format
I guess you would use the TEXT function to convert the date to a text
string, then the LEFT and MID functions to split out the individual characters, and the CONCATENATE (or &) function to glue the characters together with spaces between. -- David Biddulph wrote in message oups.com... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Format
wrote in message
oups.com... this format : 1 7 0 9 0 7. If you really mean format not have individual numbers that you can use later then Custom format as: dd mm yy -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk wrote in message oups.com... 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Format
Mr. David Biddulph
Can you show me the formulas because I can't get it correctly. Thanks CS TANG |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Format
The syntax for each of the functions that I mentioned is described in
Excel's help, with examples. -- David Biddulph wrote in message ups.com... Mr. David Biddulph Can you show me the formulas because I can't get it correctly. Thanks CS TANG |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Format
If you can use a helper cell with a formula...
With the date in A1: =TEXT(--TEXT(A1,"ddmmyy"),"0 0 0 0 0 0") 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 -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Format
In fact, =text() is pretty forgiving. I didn't need the -- to coerce the text
numbers to number numbers. =TEXT(TEXT(A1,"ddmmyy"),"0 0 0 0 0 0") Dave Peterson wrote: If you can use a helper cell with a formula... With the date in A1: =TEXT(--TEXT(A1,"ddmmyy"),"0 0 0 0 0 0") 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 -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code Date Format Depending on Computer format | Excel Discussion (Misc queries) | |||
| Convert date from text format to date format | Excel Discussion (Misc queries) | |||
| Convert date + time text format to date format | Excel Worksheet Functions | |||
| Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
| Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
Hybrid Mode
