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?