Unable to change date format in Excel
Solved/Closed
Related:
- Dash becomes date on excel
- Changing date format in excel not working - Best answers
- Change date format in excel not working - Best answers
- Date formatting in dd/mm/yyyy ✓ - Office Software Forum
- Geometry dash download pc - Download - Platform
- Danger dash unlock code ✓ - Phones, PDA & GPS Forum
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
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