Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I would like to customized format to million, but I want 0.7M for example rather than .7M as following.
Thanks
Solved! Go to Solution.
@YunJ You can do it by simply changing the Display units to milion and adding decimal places. Below is the screenshot to help you achieve it. I am not sure if you need custom format for this.
Proud to be a Super User!
Hi @negi007 Thanks for your reply. Sometimes I don't need "M", that's why I want to use custom format.
Any idea about the format string for europen standard representation? example: 100.000,00
It also works if you use it in a FORMAT function:
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |