ExcelBanter - changing the formatting of birthdates

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - changing the formatting of birthdates (https://www.excelbanter.com/excel-discussion-misc-queries/162405-re-changing-formatting-birthdates.html)

Excel_Learner

changing the formatting of birthdates

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.

All times are GMT +1. The time now is 07:03 PM.