Please enhance the custom number format option to allow for different formats depending on the value of the number being formatted, like you can do in Excel. For example: [>1000000]0.0,," M";#,##0.0 Which would produce the following formatted results: 1,232,111 -> 1.2 M 5,465 -> 5,465.0
2 Comments
This is pretty easy to do with Calculation Groups. Check this post out Creating Value Dynamic Formatting using Calculatio... - Microsoft (Web view)
- Status added:Needs Votes
