Previous Topic Next Topic

I want to change date format in Excel

Solved/Closed
EAQ - 31 May 2010 à 05:06
 mohammed - 2 Apr 2019 à 05:26
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.
Related:

2 responses

Réponse 1 / 2
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
31 May 2010 à 05:57
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
Prabhaa
6 Feb 2014 à 08:27
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
karthik
26 May 2014 à 01:16
Thx..It Worked For me..!! Thank u Very Much..Sir..!!
venu
23 Jul 2014 à 05:46
thats great , thank you
..
25 Aug 2014 à 03:13
thanks great
Teenu Jain
17 Oct 2014 à 06:24
Its really good.thanks
Réponse 2 / 2
EAQ Posts 1 Registration date Monday 31 May 2010 Status Member Last seen 31 May 2010
31 May 2010 à 05:51
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
3 Sep 2015 à 01:53
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

Similar discussions

Unable to change date format in Excel
rznbyz -
Tobby -

39 responses