Change format
 

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

Change format
 

Have you tried EditReplace?


Gord Dibben MS Excel MVP

On Mon, 15 Mar 2010 12:35:01 -0700, da wrote:

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

Change format
 

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
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"da" wrote:

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

Change format
 

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


"da" wrote:

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