That worked! Thank you
"Eric" wrote:
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
"PC" wrote:
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
"sbhayes" wrote in message
...
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?
|