Solved

# Excel Numbers: Million Round to Thousand; Hundreds to decimals; 0 show as -

Posted on 2010-11-22

I want to use the excel custom formating to show the following numbers

1,500,000 show as 1,500 note: no decimals

-1,500,000 show as (1,500) note: no decimals

150,000 show as 150 note: no decimals

-150,000 show as (150) note: no decimals

150 show as .15 note: two decimals

-150 shos as (.15) note: two decimals

0 show as "-" note: without quotation and no decimals

I would like to combine all these options under the custom formating of excel. Don't want to use formula like round function.