I want to change date format in Excel
Solved/Closed
Related:
- Unable to change date format in excel
- How to change date format in excel - Guide
- Marksheet format in excel - Guide
- How to change author in excel - Guide
- Number to words in excel - Guide
- How to change language in kmplayer - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 31, 2010 at 05:57 AM
May 31, 2010 at 05:57 AM
Click on the column that has date
go to data
choose text to column
choose delimited and click next
uncheck all the boxes and click next
click on date and choose DMY format and click finish
go to data
choose text to column
choose delimited and click next
uncheck all the boxes and click next
click on date and choose DMY format and click finish
EAQ
Posts
1
Registration date
Monday May 31, 2010
Status
Member
Last seen
May 31, 2010
May 31, 2010 at 05:51 AM
May 31, 2010 at 05:51 AM
I have data generated form SAP system. when call that data in excel, it shows date like 20.05.2010.
when I change it thru format cell it doesn't change. How do I chnage it.
when I change it thru format cell it doesn't change. How do I chnage it.
Feb 6, 2014 at 08:27 AM
I had different date format in a column-when did the above process it changed to the same date format
May 26, 2014 at 01:16 AM
Jul 23, 2014 at 05:46 AM
Aug 25, 2014 at 03:13 AM
Oct 17, 2014 at 06:24 AM