Number formatting question
 

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?

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?

One way;
In a helper cell enter 100. Copy the helper cell and highlight the rows you
wish to change. Paste Specialdivide.
HTH

"sbhayes" wrote:

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?

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?

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?