=TEXT(A1,"yyyymmdd")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"galsaba" wrote in message
oups.com...
I have a field - date. Let's say that one of the values is 6/20/05.
How can I convert it to a number field, for example 6/20/05
will be shown as 20050605?

Thanks,

galsaba