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.
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.
