#### rishijain11

##### Board Regular

- Joined
- Mar 29, 2006

- Messages
- 149

I need the following to happen

column A contains numbers....

in column B, I am trying to input a formula for custom format: so that the numbers will appear as such

column A: 32,458,000 ; column B will show +32MM

column A: -100,000 ; column B will show -100K

im currently using the below formula, but it doesn't give me the + or - sign

[>=1000000] #,##0.00,,"MM";[>0] #,##0,"K";General

in column