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
Hello,
I am working in SAP wher i generate a report which download in excel sheet in dd.mm.yyyy format but i need convert it to mm/dd/yyyy format automatically using some formula / format that will considerly save my time.
Thanks
Vijay
I am working in SAP wher i generate a report which download in excel sheet in dd.mm.yyyy format but i need convert it to mm/dd/yyyy format automatically using some formula / format that will considerly save my time.
Thanks
Vijay
Related:
- Formatting date in Excel Sheet
- Mark sheet in excel - Guide
- How to change date format in excel - Guide
- How to open excel sheet in notepad++ - Guide
- Sheet right to left in google sheet - Guide
- How to screenshot excel 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.