On Fri, 3 Aug 2007 13:38:01 -0700, Lana wrote:

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

Format/Cells/Number/Custom Type: [=1000000]#,,\M;General


But that's an odd question.

The above will display 1,000,000 as 1M and will store it as 1,000,000 that can
be used in any other arithmetic function.

Since you did not specify how you want any OTHER numbers displayed, they will
be displayed as General format.

Rather than my guessing, you might want to rethink your specifications.


--ron