Unable to change date format in Excel
Solved/Closed
Related:
- Date format not changing in excel
- Changing date format in excel not working - Best answers
- Unable to change the date format in excel - Best answers
- Excel date format dd.mm.yyyy - Guide
- Unable to authorize tiktok - TikTok Forum
- How to change time format in whatsapp - Guide
- How to change author in excel - Guide
- Unable to ping computer on same network - 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