Feb

1

Once upon a time, a fellow trader kindly tipped the way to put '+' signs into excel numbers, which inspired one to pass along the following:

Rounding Numbers to Millions

To round 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

No doubt this will give that trendy 'white space' look of many a Spec's balance sheet.


Comments

WordPress database error: [Table './dailyspeculations_com_@002d_dailywordpress/wp_comments' is marked as crashed and last (automatic?) repair failed]
SELECT * FROM wp_comments WHERE comment_post_ID = '814' AND comment_approved = '1' ORDER BY comment_date

Name

Email

Website

Speak your mind

Archives

Resources & Links

Search