Date Format

  • Thread starter Thread starter cstang999
  • Start date Start date
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
 
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)
 
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.
 
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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Mr. David Biddulph

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

CS TANG
 
The syntax for each of the functions that I mentioned is described in
Excel's help, with examples.
 
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")
 
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")
 
Back
Top