ExcelBanter - Excel dates change

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel dates change (https://www.excelbanter.com/excel-worksheet-functions/55027-excel-dates-change.html)

Mags

Excel dates change

I have a report which displays a column of birthdays in a mm/dd/yyyy format;
how can I change it to a dd-mm-yyy format? Thanks

Gary''s Student

Excel dates change

Format Cells... Number Custom and use
dd-mm-yyyy
or
dd-mm-yy

yyy is not an option since Excel doesn't know if its the first or last three
digits.
--
Gary''s Student

"Mags" wrote:

I have a report which displays a column of birthdays in a mm/dd/yyyy format;
how can I change it to a dd-mm-yyy format? Thanks

All times are GMT +1. The time now is 09:49 PM.