custom formats

[Flipper]

How can I format 31,840,000 to appear as 31.84M, and or 35,000,000 as 35M?

Thanks

 

[מיכ×ל (מיקי) ×בידן]

You may try this: 0.##,,"M"
Micky

 

[Flipper]

That works, thank you so much.
--
Allan

You may try this: 0.##,,"M"
Micky