formatting $ values to reduce cell size

%3CLINGO-SUB%20id%3D%22lingo-sub-2810065%22%20slang%3D%22en-US%22%3Eformatting%20%24%20values%20to%20reduce%20cell%20size%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2810065%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20display%20for%20example%20%2410%2C200%2C000%20as%20%2410.2mm%20so%20I'm%20able%20to%20reduce%20the%20size%20of%20the%20cell%20that%20value%20is%20displayed%20in.%20But%20I%20need%20to%20retain%20the%20cell%20formatted%20for%20%24%20since%20I've%20got%20calculations%20connected%20to%20the%20cell.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2810065%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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.

1 Reply

@flash51 

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.