Excel number formatting (thousands)

[Loller]

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

[#2]

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