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