View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
evoxfan evoxfan is offline
external usenet poster
 
Posts: 65
Default Simple conversion

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.