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

"Manish Bajpai" wrote:

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

"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.