Change date format
Closed
Mani
-
16 Jul 2015 à 06:11
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 21 Jul 2015 à 11:16
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 21 Jul 2015 à 11:16
Related:
- Change date format
- How to change date format in excel - Guide
- Kingston format utility - Download - Storage
- Hdd low level format tool - Download - Storage
- Format factory for pc - Download - Other
- Hp format tool - Download - Storage
2 responses
Computertech
Posts
3569
Registration date
Friday 6 February 2015
Status
Contributor
Last seen
18 July 2016
893
16 Jul 2015 à 06:21
16 Jul 2015 à 06:21
M.Hanzla
Posts
14
Registration date
Thursday 16 July 2015
Status
Member
Last seen
14 August 2015
1
16 Jul 2015 à 06:43
16 Jul 2015 à 06:43
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 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
16 Jul 2015 à 11:29
16 Jul 2015 à 11:29
That won't work for formatted cells M.Hanzla.
M.Hanzla
Posts
14
Registration date
Thursday 16 July 2015
Status
Member
Last seen
14 August 2015
1
>
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
20 Jul 2015 à 08:50
20 Jul 2015 à 08:50
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 16 July 2015
Status
Member
Last seen
14 August 2015
1
>
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
20 Jul 2015 à 08:55
20 Jul 2015 à 08:55
now i tried with formatted cell and it did work dear :)
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
20 Jul 2015 à 11:08
20 Jul 2015 à 11:08
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 16 July 2015
Status
Member
Last seen
14 August 2015
1
21 Jul 2015 à 05:30
21 Jul 2015 à 05:30
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 :)
