Rounding Numbers to Millions

India
February 20, 2007 6:50am CST
Excel by default does not round numbers to millions. So here's a way to tweak Excel. To round a numbers to millions: 1. Press Ctrl+1 to open the Format Cells dialog box. 2. Select the Number tab, and from Category, select Custom. 3. In the Type box, enter the following Custom Formatting syntax: #,##0,, ;[Red](#,##0,,);- ; Result: • Original number: 5,645,625 • The displaying formatted number: 6 Note: The number formatting syntax is: Positive; Negative; 0; Text Cheers! ~~SiFaR~~ http://sifar.ueuo.com
1 response
@sunny1984 (640)
• India
23 Feb 07
tanx friemd to advice
• India
23 Feb 07
u r welcome friend. If u wish, u can go ahead & rate me... Cheers! Eijaz