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