Try =YEAR(A1)*10000+MONTH(A1)*100+DAY(A1)
But you MUST format the cell after typing the formula because Excel wants a
date format

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"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