Hi everyone
I would like to display:
1,200,000 as $1.2M & 120,000 as $120K as well as -1,200,000 as -$1.2M & -120,000 as -$120k for a range of cell
In order to do that I know that for the positive number the format is :
[>=1000000] $#,##0.0,,"M";[>0] $#,##0.0,"K";General
and for negative:
[<= -1000000]-$#,##0.0,,"M";[<0]-$#,##0.0,"K";General
however I need a macro that apply these two different set of format depending on whether the number is positive or negative, also the number that I need to be formatted come from a formula and are not typed in
any help would be greatly appreciated
I would like to display:
1,200,000 as $1.2M & 120,000 as $120K as well as -1,200,000 as -$1.2M & -120,000 as -$120k for a range of cell
In order to do that I know that for the positive number the format is :
[>=1000000] $#,##0.0,,"M";[>0] $#,##0.0,"K";General
and for negative:
[<= -1000000]-$#,##0.0,,"M";[<0]-$#,##0.0,"K";General
however I need a macro that apply these two different set of format depending on whether the number is positive or negative, also the number that I need to be formatted come from a formula and are not typed in
any help would be greatly appreciated