Lana,

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

To accomplish this go to FormatCells...([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

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