How to display 1,000,000 as 1M

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

What you are looking for is to change the number format of the cell.

To accomplish this go to Format>Cells...([Ctrl] + 1)>Number tab, under
"Category:" select "Custom" (last item in the list), in the "Type" text box
type your number format.

The following is a list of number formats and how the value of 1,000,000
will be displayed (keep in mind there are 4 parts (positive, negative, zero,
and text) to the number format and I'm only showing you the positve number
format);

#,##0.00 1,000,000.00
#,##0 1,000,000
0, 1000
#,##0, 1,000
0,, 1
0,,\M 1M
0.00,,\M 1.00M
0,," Mil" 1 Mil
0.00,," Mil" 1.00 Mil

All of these are different ways of displaying the value 1,000,000. You will
still enter it as a 1 followed by 6 zeros and it will be the value of
1,000,000 in any calculation you use this/these cell(s) in.

Please go to Help and look up number formats to learn what all of the
different codes mean and how to format each of the 4 parts of the number
format.

HTH,

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

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
 
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"
 
Back
Top