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

EAQ - May 31, 2010 at 05:06 AM - Latest reply:  d
- Mar 17, 2018 at 05:16 PM

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 

12 replies

Best answer
rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - May 31, 2010 at 05:57 AM
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

Thank you, rizvisa1 21

Something to say? Add comment

CCM has helped 1591 users this month

Its really good.thanks
Hats-Off To You Boss.
thanks mate - saved me some precious time
EAQ 1 Posts Monday May 31, 2010Registration date May 31, 2010 Last seen - May 31, 2010 at 05:51 AM
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