How to "move" a decimal for a column of values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column of monetary values that was incorrectly formatted with an incorrect decimal. For example, a number is shown as 167200, but really should be 16.72. All numbers have the two unneeded trailing zeros. Is there an easy way to reformat the entire column to correct the decimal, rather than dividing each cell individually?
 
Cindy

Type 10000 in an unused cell. Copy it. Select your range and select
Paste/Special/Divide.

Andy.

Cindy B. said:
I have a column of monetary values that was incorrectly formatted with an
Click to expand...
incorrect decimal. For example, a number is shown as 167200, but really
should be 16.72. All numbers have the two unneeded trailing zeros. Is
there an easy way to reformat the entire column to correct the decimal,
rather than dividing each cell individually?
 
Cindy,

put 10000 in a cell, copy it, select the range with the numbers,
do edit>paste special and select divide

You might want to do this on a back up copy in case not all numbers
are like this..

--

Regards,

Peo Sjoblom


Cindy B. said:
I have a column of monetary values that was incorrectly formatted with an
Click to expand...
incorrect decimal. For example, a number is shown as 167200, but really
should be 16.72. All numbers have the two unneeded trailing zeros. Is
there an easy way to reformat the entire column to correct the decimal,
rather than dividing each cell individually?
 
I guess that you really mean that you want to change an actual number
from 167200 rather than change the format via Format/Cells. You
therefore have to divide each one by 10000.

Put the number 10000 into any empty cell and Edit/Copy it.

Select the numbers you wish to change. Edit/Paste Special/ ... Values
... Multiply ... OK.
 
Back
Top