SoudeDia
New member
- Joined
- Aug 25, 2013
- Messages
- 9
- Reaction score
- 0
- Points
- 0
- Location
- Tampa Bay, FL
- Excel Version(s)
- 16, 365
Our company has a unique currency reporting format. Thousands are "M", Millions are "MM". I have crafted the format with one small issue. The negative currency does not do the "MM", only "M". Can anyone help me fix this formula? Oh, negatives should also be red and in parenthesis. Currency: [>=1000000] $#,##0.0,," MM";[>0] $#,##0.0," M";[Red]($#,###," M").