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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 21, 2015 at 11:16 AM
Related:
- Change date format
- How to change date format in excel - Guide
- Format factory - Download - Other
- Change computer name cmd - Guide
- Kingston format utility - Download - Storage
- Change lg tv name - Guide
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
Jul 16, 2015 at 06:21 AM
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
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 :)
2-ctrl+F
3-in find put "." (dot) and in replace put "/"
4-replace all
and done :)
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jul 16, 2015 at 11:29 AM
Jul 16, 2015 at 11:29 AM
That won't work for formatted cells M.Hanzla.
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
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
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
Jul 20, 2015 at 08:55 AM
now i tried with formatted cell and it did work dear :)
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jul 20, 2015 at 11:08 AM
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
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
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
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 :)
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 :)
