Forum Discussion
Excel number formatting (thousands)
How to I display a number in thousands or millions. Examples: $10,000.00 on thousands displays as $10.0 $10,000,000.00 displays in millions as $10.0 without using formulas
To display $10,000.00 as $10.0, apply the custom number format $#,##0.0, (including the comma at the end!)
To display $10,000,000.00 as $10.0, apply the custom number format $#,##0.0,, (including the 2 commas at the end!)