Date format Change

Hai All,

probably a simple question. I am downloading data from an ODS. I have dates int he format 8/3/2006. I need to upload this data after modifications as a flat file. But the date format in flat file needs to be in 20060803 format.

I am saving this data to excel.

How can I convert this automatically?

Thank you.