Hi everyone
I would like to display:
$1.2M as 1,200,000 & 120K as $120,000 as well as -$1.2M as -1,200,000 & -$120k as -120,000 for a range of cells
I Know that the opposite can be done with
[>=1000000] $#,##0.0,,"M";[>0] $#,##0.0,"K";General
and for negative:
[<= -1000000]-$#,##0.0,,"M";[<0]-$#,##0.0,"K";General
The numbers in question come from a web data import
any help would be greatly appreciated!
I would like to display:
$1.2M as 1,200,000 & 120K as $120,000 as well as -$1.2M as -1,200,000 & -$120k as -120,000 for a range of cells
I Know that the opposite can be done with
[>=1000000] $#,##0.0,,"M";[>0] $#,##0.0,"K";General
and for negative:
[<= -1000000]-$#,##0.0,,"M";[<0]-$#,##0.0,"K";General
The numbers in question come from a web data import
any help would be greatly appreciated!