Unable to change date format in Excel
Solved/Closed
Hello,
I have an excel worksheet with a date column, the format is set to dd-mmm-yyyy but the dates in the columns display as mm/dd/yyyy. If I double click in each individual cell and then move out of that cell the format changes and the dates appear correct. I have 24854 dates I need to change, I can't take time to double click in each cell. Any suggestions? Thanks
I have an excel worksheet with a date column, the format is set to dd-mmm-yyyy but the dates in the columns display as mm/dd/yyyy. If I double click in each individual cell and then move out of that cell the format changes and the dates appear correct. I have 24854 dates I need to change, I can't take time to double click in each cell. Any suggestions? Thanks
Related:
- Dash becomes date on excel
- Changing date format in excel not working - Best answers
- Excel date format won't change - Best answers
- Date formatting in dd/mm/yyyy ✓ - Office Software Forum
- Geometry dash download pc - Download - Platform
- Excel date format dd.mm.yyyy - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
5 responses
This works:
That works.
-24
- First change your format to the specific date that you want for your column of data.
- With the column selected, select "Copy"
- Open notepad (NOT WORD, it has to be notepad)
- Paste your data into notepad.
- In notepad, press CTRL + A (selects all cells) then press CTRL + C (copies data)
- Paste data back into Excel.
- It will say something about size not being the same, paste it anyways.
That works.
-24
Jun 11, 2010 at 08:13 AM
Dec 7, 2010 at 07:00 PM