Change date format

[Closed]
Report
-
Posts
2779
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 29, 2021
-
Hello,
I Want to change date format dd.mm.yyyy to dd/mm/yyyy in MS Excel 2010
Please solve my problem urgently


2 replies

Posts
3569
Registration date
Friday February 6, 2015
Status
Moderator
Last seen
July 18, 2016
844
Posts
14
Registration date
Thursday July 16, 2015
Status
Member
Last seen
August 14, 2015
1
1-select the whole date column
2-ctrl+F
3-in find put "." (dot) and in replace put "/"
4-replace all
and done :)
Posts
14
Registration date
Thursday July 16, 2015
Status
Member
Last seen
August 14, 2015
1 >
Posts
2779
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 29, 2021

thnx for informing trowad :) may be i dint try it on formatted cells but it worked for me
Posts
14
Registration date
Thursday July 16, 2015
Status
Member
Last seen
August 14, 2015
1 >
Posts
2779
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 29, 2021

now i tried with formatted cell and it did work dear :)
Posts
2779
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 29, 2021
468
Hi M.Hanzla,

Well, when I enter a date like 15-7-15 and format that date as dd.mm.yyyy, find and replace doesn't work for me at least. Replacing "." with "/" or "-" with "/" both result 15.07.15 as the cell is formatted.

Did you do something different or do our Excel versions (I'm using 2013) behave differently?

Best regards,
Trowa
Posts
14
Registration date
Thursday July 16, 2015
Status
Member
Last seen
August 14, 2015
1
ok dear now i completely understand what you were trying to say
That is "custom Format" you are talking about.In case of custom format i used a trick that always work
1-copy the whole column of date
2-open notpad and press ctrl+v
3-press ctrl+a(to select All)
4-in edit you will find replace.replace "." with whatever u want and click replace all(ctrl+H shortcut)
5-copy all dates to paste in excel again and done :)
Posts
2779
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 29, 2021
468
Well, I would have to use custom format, since the date format with dots doesn't exist in my list of date formats.

And to change it, I would change the custom format, but thanks for letting us know your workaround.

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!