Forum Discussion
Loller
Feb 25, 2021Copper Contributor
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
- DavidLambeCopper Contributor
Thank you HansVogelaar This had been bugging me for a while now. The custom number format #,##0 had no impact but adding a comma at the end or two comma's at the end was thre missing piece of the puzzle.
I'm glad it helped you!
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!)