Click on Format Cell--custom--and type dd/mm/yyyy.
Hope it will help you.

"Donna" wrote:

I have an Excel file with the birthdate field formatted as yyyymmdd and I
need to export it as a .csv file with the date formatted as mm/dd/yyyy (the
change in order and the slashes are critical). I know how to save as a .csv
file, but I cannot figure out how to change the date formatting.