Formula for making a number 3 digits less...

[johnnyrad]

If I have a value, say $1,000,000 and I want to show it as $1,000 (w
note at the top its in thousands)... I know i can just divide by 100
to get that result, but is there an actual formula name that doe
this... just curious

 

[Ron Rosenfeld]

If I have a value, say $1,000,000 and I want to show it as $1,000 (we
note at the top its in thousands)... I know i can just divide by 1000
to get that result, but is there an actual formula name that does
this... just curious.

Well if you divide by 1000 then you also change the contents of the cell.

If you really want to just "show" it as $1,000 but have the value still be
$1,000,000 then you can use a custom format of

$#,##0,

Format/Cells/Number/Custom/ Type: $#,##0,

Be sure to include the trailing comma.


--ron

 

[Frank Kabel]

Hi
use the custom format
#,#,

 

[Gord Dibben]

Johnny

Custom Format #,

Gord Dibben Excel MVP