Change format

  • Thread starter Thread starter da
  • Start date Start date
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
 
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
 
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
 
Back
Top