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

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

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

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

Date Format
 

Mr. David Biddulph

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

CS TANG

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

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

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