Excel number formatting (thousands)

%3CLINGO-SUB%20id%3D%22lingo-sub-2166589%22%20slang%3D%22en-US%22%3EExcel%20number%20formatting%20(thousands)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2166589%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20to%20I%20display%26nbsp%3B%20a%20number%20in%20thousands%20or%20millions.%3C%2FP%3E%3CP%3EExamples%3A%20%2410%2C000.00%20on%20thousands%20displays%20as%20%2410.0%3C%2FP%3E%3CP%3E%2410%2C000%2C000.00%20displays%20in%20millions%20as%20%2410.0%20without%20using%20formulas%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2166589%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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

 

1 Reply

@Loller 

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!)