Change format

D

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
 
G

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
 
F

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
 
Top