Find replace problem
Here is a way to achieve this effect without using Find/Replace:
1. Highlight your column, then Forman- Cells- Custom
2. the format your cells should be in is hh:mm:ss. In the Type: text box,
change this format to hh:mm.ss
Now, your column should be fixed.
--
Anne Murray
" wrote:
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
|