Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
I have some numbers denoted thus:- 02:34:56 (they can be any numbers at all separated by Colons and I want to replace the last Colon with a dot/period so it is 02:34.56 I tried to replace using **:**:** to **:**.** but it fills in with the latter How can I achieve please Neil |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find and replace - problem with automatically changing formatting | Excel Discussion (Misc queries) | |||
Problem with Find and Replace | Excel Worksheet Functions | |||
Find and replace of word causes change of font formatting | New Users to Excel | |||
Can I use Find and Replace all with Hyperlinks? | Excel Discussion (Misc queries) | |||
macro to Find Replace in Excel | Excel Discussion (Misc queries) |