If you have a "text" date, in A1, use this.........
=RIGHT(A1,4)&MID(A1,FIND("/",A1,1)+1,2)&LEFT(A1,2)

Vaya con Dios,
Chuck, CABGx3


"Ana" wrote in message
...
Hi,

I need to convert the date format dd/mm/yyyy to yyyymmdd.

How would I go by?

TIA

Ana