Forum Discussion

YunJ's avatar
YunJ
Post Prodigy
5 years ago
Solved

Customize format to million

Hi, I would like to customized format to million, but I want 0.7M for example rather than .7M as following.  Thanks  
Need Help
  • nandukrishnavs's avatar
    nandukrishnavs
    5 years ago

    YunJ 

     

    Try below format string

    #,##0,,.0M

     

negi007's avatar
negi007
Community Champion
5 years ago

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.

 

 

  • YunJ's avatar
    YunJ
    Post Prodigy
    5 years ago

    Hi negi007 Thanks for your reply. Sometimes I don't need "M", that's why I want to use custom format.