S
sbhayes
I have hundreds of rows of numbers (example 234553) it need to add a decimal
to every row to make it 2345.53. Is this possible?
to every row to make it 2345.53. Is this possible?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
PC
Yes
One method
Put the value 100 in a blank cell.
With that cell selected, Edit/Copy
Select the numbers you wish to change (highlight the column)
Use Edit/Paste Special and select the Divide option.
HTH
PC
One method
Put the value 100 in a blank cell.
With that cell selected, Edit/Copy
Select the numbers you wish to change (highlight the column)
Use Edit/Paste Special and select the Divide option.
HTH
PC
R
Ray A
One way;
In a helper cell enter 100. Copy the helper cell and highlight the rows you
wish to change. Paste Special>divide.
HTH
In a helper cell enter 100. Copy the helper cell and highlight the rows you
wish to change. Paste Special>divide.
HTH
E
Eric
Or you could just add a new column in and make each cell in the new column
equal to the corresponding cell in the old column in divided by 100.
Eric
equal to the corresponding cell in the old column in divided by 100.
Eric
S
sbhayes
That worked! Thank you
Eric said:Or you could just add a new column in and make each cell in the new column
equal to the corresponding cell in the old column in divided by 100.
Eric