Thread: Change format
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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