Few months back I wrote a post on rounding numbers to no decimal place with a macro. It is particularly useful when you have too many numbers in a spreadsheet like financial model. Please pardon my ignorance, Excel has a mouse based shortcut to do this.
Home -> Style -> Cell styles -> Number format -> Comma
648523.2363 -> Comma -> 648,523
I m just came to know about it a little late