Formating

[simmy1234]

Hi There


Please help, I need format my number in millions please help me with the custom format

i need to use or any other method.


Thanks

 

[Luke M]

Do you want any decimals?

Example number of 12,345,678


Want this?

12 M

Format:

#,," M"


Want this?

12M

Format:

#,,"M"


Want this?

12.3 M

Format:

#.#,," M"


Or this?

12.34 Million

Format:

#.##,," Million"

 

[simmy1234]

Thanks a lot.