Simple conversion
what you can do is highlight the column of data (only the data, not the
entire column), click data, then click text to columns,
check the delimited box, click the other box, put a '-' in the box and click
next,
then click a cell as the destination and it will put the numbers on the
front of the '-' in the cell and the numbers on the back of the dash, in the
next cell...
then enter a '.' in one cell...
Then out to the right side of the two columns of data enter:
=cell1 '&' ((cell with the period in it) and lock it down with F4) &cell2
then drag the formula down and voila...
"evoxfan" wrote:
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.
|