Formatting date in Excel Sheet
Closed
vijay
-
May 10, 2011 at 12:37 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - May 10, 2011 at 01:44 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - May 10, 2011 at 01:44 AM
Related:
- Formatting date in Excel Sheet
- Excel date format dd.mm.yyyy - Guide
- Mark sheet in excel - Guide
- How to screenshot excel sheet - Guide
- How to open excel sheet in notepad++ - Guide
- Little alchemy cheat sheet - Guide
1 response
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
May 10, 2011 at 01:44 AM
May 10, 2011 at 01:44 AM
This works:
1) First change your format to the specific date that you want for your column of data.
2) With the column selected, select "Copy"
3) Open notepad (NOT WORD, it has to be notepad)
4) Paste your data into notepad.
5) In notepad, press CTRL + A (selects all cells) then press CTRL + C (copies data)
6) Paste data back into Excel.
7) It will say something about size not being the same, paste it anyways.
That works.
1) First change your format to the specific date that you want for your column of data.
2) With the column selected, select "Copy"
3) Open notepad (NOT WORD, it has to be notepad)
4) Paste your data into notepad.
5) In notepad, press CTRL + A (selects all cells) then press CTRL + C (copies data)
6) Paste data back into Excel.
7) It will say something about size not being the same, paste it anyways.
That works.
