Report

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

Ask a question EAQ - Last answered on Sep 11, 2017 at 07:38 AM by arsomesh
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.
Helpful
+24
plus moins
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
Was this answer helpful?  
venu- Jul 23, 2014 at 05:46 AM
thats great , thank you
..- Aug 25, 2014 at 03:13 AM
thanks great
Teenu Jain- Oct 17, 2014 at 06:24 AM
Its really good.thanks
007- Apr 17, 2015 at 08:23 AM
thanks Dude
arsomesh- Sep 11, 2017 at 07:38 AM
Hats-Off To You Boss.
Reply
Helpful
+1
plus moins
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.
ganesh ray- Sep 3, 2015 at 01:53 AM
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

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!