Changing format of date in Excel
Solved/Closed
Related:
- Excel date format won't change
- Excel date format dd.mm.yyyy - Guide
- How to change whatsapp time format - Guide
- How to change author in excel - Guide
- Format factory - Download - Other
- Marksheet format in excel - Guide
22 responses
kelly7898
Posts
4
Registration date
Monday April 26, 2010
Status
Member
Last seen
April 26, 2010
Apr 26, 2010 at 04:42 AM
Apr 26, 2010 at 04:42 AM
It took me a while to find a solution to an existing list of dates, (which is what I am assuming you are working with). In my case I had international date (dd/mm/yyyy) and wanted a U.S. view (mm/dd/yyyy).
Select the Column range you want to convert (must be continuous), then click on 'Data', click 'Next' twice (ignoring the Delimted vs Fixed Width Choice & the Delimiter character, then select DMY or MDY from the drop down list. In my case, since my OP system is U.S. but the spreadsheet came from overseas, I had to go with a DMY to 'clean up"
_________________
https://www.dynadot.com/forsale/moviesonlinefree.biz?drefid=2071
Select the Column range you want to convert (must be continuous), then click on 'Data', click 'Next' twice (ignoring the Delimted vs Fixed Width Choice & the Delimiter character, then select DMY or MDY from the drop down list. In my case, since my OP system is U.S. but the spreadsheet came from overseas, I had to go with a DMY to 'clean up"
_________________
https://www.dynadot.com/forsale/moviesonlinefree.biz?drefid=2071
