I want to change date format in Excel

Solved/Closed
EAQ - May 31, 2010 at 05:06 AM
 mohammed - Apr 2, 2019 at 05:26 AM
Hello,

I want to change date format from SAP system i.e. 20.05.2010.

When I apply thru format cell it doesn't work.

2 replies

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
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
22
Thats great it worked for me rizvisa1.
I had different date format in a column-when did the above process it changed to the same date format
0
Thx..It Worked For me..!! Thank u Very Much..Sir..!!
0
thats great , thank you
0
thanks great
0
Its really good.thanks
0
EAQ Posts 1 Registration date Monday May 31, 2010 Status Member Last seen May 31, 2010
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.
1
hi friend,
select the cell and go to DATA in menu bar then go to text to column and then select uncheck and then next again next and then select the MDY and then finish
0