Change format

[da]

Hello
Is there a way to change the following in hh:mm:ss?
Instead of 22.14.15, I want it to change it to 22:24:15 (replace dot with
colon?)
I have few hundred entries which need to be changed. It will be too time
consuming to change manually.
Thank you

22.24.15
01.53.59
07.30.19
15.31.13

 

[Gord Dibben]

Have you tried Edit>Replace?


Gord Dibben MS Excel MVP

 

[Gary Brown]

Assuming the 22.24.15 is text and in Cell A1...
=TIME(LEFT(A1,2),MID(A1,4,2),RIGHT(A1,2))
Then custom format as...
hh:mm:ss or
hh:mm:ss AM/PM

 

[FSt1]

hi
i think dave peterson answered your question about 10 posts ago.
find and replace.
press Ctlr+F
click the replace tab.
in the find box enter . (dot)
in the replace box enter : (colon)
click replace all

Regards
FSt1