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