How to format numbers that are already entered?

[Guest]

I copied a huge spreadsheet. I need to change the numbers in one column to
reflect 2 decimal places. But the decimal place must go within the numbers
already there and not add zeroes then the decimal. I have tried to customize
the cell but it is not coming out the way i want it to be. For example 356322
should read 3,563.22. Please help me.

 

[Guest]

That's more than a formatting issue. You need to actually change the values
of the cells.

Try this:

1)Put 100 in an empty cell and select the cell.
2)Edit>Copy
3)Select the range of cells that need to be changed.
4)Edit>PasteSpecial
---select values
---select divide
---Click the [OK] button
(then press Escape to cancel copy/paste mode)

That will change the values. Now you can adjust the number format to suit
your needs.

Does that help?

 

[Guest]

Simply divide the entire column by 100 and then format cells to show number
with 2 decimal places and don't forget to check the Comma.

Thanks,

Manish Bajpai

 

[Guest]

Thanks Ron. It worked.

Muriel

That's more than a formatting issue. You need to actually change the values
of the cells.

Try this:

1)Put 100 in an empty cell and select the cell.
2)Edit>Copy
3)Select the range of cells that need to be changed.
4)Edit>PasteSpecial
---select values
---select divide
---Click the [OK] button
(then press Escape to cancel copy/paste mode)

That will change the values. Now you can adjust the number format to suit
your needs.

Does that help?

--
Regards,
Ron

I copied a huge spreadsheet. I need to change the numbers in one column to
reflect 2 decimal places. But the decimal place must go within the numbers
already there and not add zeroes then the decimal. I have tried to customize
the cell but it is not coming out the way i want it to be. For example 356322
should read 3,563.22. Please help me.

 

[Guest]

Thanks Manish. I believe it would have worked since it was similar to Ron's
answer, the only problem I had was getting the formula to work. However, I
have gotten a solution to my worksheet issue.

Muriel