Special Currency Format

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").
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
I have never got a format to do all of what you ask, so I tend to revert to event code to test the value and set the format accordingly.
 
Top