Simple conversion
Ctrl + h then find what -
replace with .
then a custom format
or a help cell
=SUBSTITUTE(A1,"-",".")
then copy and paste special as values
--
Regards,
Peo Sjoblom
"evoxfan" wrote in message
...
I have a column of numbers such as:
030-000
033-020
033-030
123-456
I would like to convert these numbers to:
030.000
033.020
033.030
123.456
What is the best way to accomplish this?
I would like to keep six digits even if the number begins with "0" or ends
with "000".
Thanks in advance.
|