Change date format

Closed
Mani - Jul 16, 2015 at 06:11 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 21, 2015 at 11:16 AM
Hello,
I Want to change date format dd.mm.yyyy to dd/mm/yyyy in MS Excel 2010
Please solve my problem urgently


2 responses

Computertech Posts 3569 Registration date Friday February 6, 2015 Status Moderator Last seen July 18, 2016 893
Jul 16, 2015 at 06:21 AM
0
M.Hanzla Posts 14 Registration date Thursday July 16, 2015 Status Member Last seen August 14, 2015 1
Jul 16, 2015 at 06:43 AM
1-select the whole date column
2-ctrl+F
3-in find put "." (dot) and in replace put "/"
4-replace all
and done :)
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Jul 16, 2015 at 11:29 AM
That won't work for formatted cells M.Hanzla.
0
M.Hanzla Posts 14 Registration date Thursday July 16, 2015 Status Member Last seen August 14, 2015 1 > TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022
Jul 20, 2015 at 08:50 AM
thnx for informing trowad :) may be i dint try it on formatted cells but it worked for me
0
M.Hanzla Posts 14 Registration date Thursday July 16, 2015 Status Member Last seen August 14, 2015 1 > TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022
Jul 20, 2015 at 08:55 AM
now i tried with formatted cell and it did work dear :)
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Jul 20, 2015 at 11:08 AM
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
0
M.Hanzla Posts 14 Registration date Thursday July 16, 2015 Status Member Last seen August 14, 2015 1
Jul 21, 2015 at 05:30 AM
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 :)
0