Use a formula like

=TEXT(A1,"yyyymmdd")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Lamb Chop" wrote in message
...
How to convert date to text?

e.g

13-05-2006 (in date format)

to

20060513 (as text)


Thanks

Man