Thanks Ron. It worked.
Muriel
"Ron Coderre" wrote:
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)EditCopy
3)Select the range of cells that need to be changed.
4)EditPasteSpecial
---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
"Muriel" wrote:
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.
|