Formula for making a number 3 digits less...

J

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
 
R

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.
Click to expand...

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
 
Top