If you haven't had this answer yet:

Choose Format, Cells, Number tab, Custom and enter the following on the Type
line:

#,,"M"

or
0,,"M"

--
Cheers,
Shane Devenshire


"Lana" wrote:

How to display 1,000,000 as 1M and then later use it in sum function as a
million? Thank you