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