Home | Post | Comments  | Go Bottom  | NavBar:

Nov 2, 2009

How to excel customizing number format in billion, million, thousand

In Microsoft Excel to show the result of number in billion, million or thousand, you can use a custom number format by not changing the number of digits.
For example, the result is like this:



The custom number format applied to the format number above is set by using Format -> Cells -> Customer -> Type



To show the billion format _(* #,##0,,,_);[Red]_(* (#,##0,,,);_(* "-"???_);_(@_)
To show the Million format _(* #,##0,,_);[Red]_(* (#,##0,,);_(* "-"??_);_(@_)
To show the thousand format _(* #,##0,_);[Red]_(* (#,##0,);_(* "-"_);_(@_)
syntax [Red] to show negatif number in red color and between brackets ()

2 comments:

Rob Lee said... February 6, 2013 at 10:29 PM

Is there a way to custom format, billions OR millions OR thousands?

Frank said... May 28, 2013 at 11:42 PM

Specify conditions To specify number formats that will be applied only if a number meets a condition that you specify, enclose the condition in square brackets. The condition consists of a comparison operator (comparison operator: A sign that is used in comparison criteria to compare two values. Operators include: = Equal to, > Greater than, < Less than, >= Greater than or equal to, <= Less than or equal to, and <> Not equal to.) and a value. For example, the following format displays numbers that are less than or equal to 100 in a red font and numbers that are greater than 100 in a blue font.
[Red][<=100];[Blue][>100]

Post a Comment