Date Format

C

cstang999

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
 
B

Bob Phillips

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)
 
D

David Biddulph

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.
 
S

Sandy Mann

this format : 1 7 0 9 0 7.
Click to expand...

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
C

cstang999

Mr. David Biddulph

Can you show me the formulas because
I can't get it correctly. Thanks

CS TANG
 
D

David Biddulph

The syntax for each of the functions that I mentioned is described in
Excel's help, with examples.
 
D

Dave Peterson

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")
 
D

Dave Peterson

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")
 
Top