Oct 04 2021 11:21 AM
Is there a way to display for example $10,200,000 as $10.2mm so I'm able to reduce the size of the cell that value is displayed in. But I need to retain the cell formatted for $ since I've got calculations connected to the cell.
Oct 04 2021 11:39 AM
Apply the custom format
$#,##0.0,,"mm"
to the cells. Each comma after the regular number format divides the displayed value by a thousand, so two commas divide by a million. The underlying value is unaltered.