if you really need it as text
=text(A1,"ddmmyyyyy")
assuming it is days before months if not
=text(A1,"mmddyyyyy")

"HelenONeill" wrote:

I have dates set as 01/01/2000 and I need to convert to 01012000.