Conditional formatting numbers

[pangea17]

Is it possible to make a conditional formula that will display numbers as millions when the number is => $1 MM or as the number when it is less than $1MM? E.G. $1,230,410 displays as $1.2 MM and 864,230 displays as $864,230. The custom format for the former is $#0.0,, "MM".

 

[Rick Rothstein]

Give this Custom Format a try...

[<1000000]$#,##0;$0.0,," MM"

 

[pangea17]

Thanks a lot. You are a genius!