Number Formats in Microsoft Excel

Thousands, Millions, etc.

If you use a number format like0, Excel simply writes the number with no decimal point or decimal digits. To truncate the last three digits of a number in the thousands, append a comma to the number format, like this:0,. Two commas drop off two sets of three digits, etc. To add a character after the number, K for thousands, append it in quotes:0,"K". Here are a few sample formats for a number in the thousands:

Number Format	How 12,345.678 is displayed
0	12345
#,##0	12,345
0.00	12345.68
0,	12
0.00,	12.35
0,"K"	12K
0.00,"K"	12.35K

Here is a conditional number format that shows numbers as millions with an M, thousands with a K, or as numbers:

[>=1000000]0,,"M";[>=1000]0,"K";0

Here is how some numbers appear in this format:

Number	As displayed using [>=1000000]0,,"M";[>=1000]0,"K";0
0.1	0
1	1
10	10
100	100
1,000	1K
10,000	10K
100,000	100K
1,000,000	1M
10,000,000	10M
100,000,000	100M
1,000,000,000	1000M