I want to change date format in Excel [Solved/Closed]

- - Latest reply:  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.
See more 

2 replies

Best answer
Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
752
22
Thank you
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

Say "Thank you" 22

Glad we were able to help! Love us? Write us a review! Rate CCM

CCM 6297 users have said thank you to us this month

Hats-Off To You Boss.
Cool....thanks
thanks mate - saved me some precious time
Posts
1
Registration date
Monday May 31, 2010
Status
Member
Last seen
May 31, 2010
1
Thank you
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.
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