To add commas to your numbers:
Select the cell(s) that you want to format.
Go to the Format menu, and click Cells.
A Format Cells window will appear.
Click the Number tab.
In the Category box, click Fixed.
A list of fixed decimal types (which include commas) will appear in the Type box. Click on a type to select it. When you click on a type, a Sample will be displayed below.
After selecting a type, click OK.
The formatting will be applied to the selected cell(s). Note the that numbers will be values, and thus, can be used in calculations. They will also be included in row and column totals.
Note: To quickly access the number formatting window, go to the Format menu, and click Number formatting.
Comma Formatting in Advanced Mode
To apply comma formatting in Advanced Mode:
Select the cell(s) that you want to format.
FIXED function
FIXED(number, precision, no_commas)
Parameter |
Description |
number |
number you want to fix |
precision |
number of decimal places |
no_commas |
if TRUE, result will have no commas; if FALSE or omitted, result will have commas |
Users experienced in entering formulas may prefer to use the FIXED function. To use this function:
Click on the cell you want the insert the fixed value into.
Type in a formula. For example, for 5,000, type =FIXED(5000, 0, FALSE), or simply =FIXED(5000, 0).
Press Enter. The result of your formula will appear in the cell. Note that this result can be used in basic calculations (addition, multiplication, subtraction, division); however, it will not be included in totals and subtotals.
Examples:
Formula |
Result |
=FIXED(5000, 0, TRUE) |
5000 |
=FIXED(5000, 0, FALSE) |
5,000 |
=FIXED(5000, 2, FALSE) |
5,000.00 |
=FIXED(5000, 2) |
5,000.00 |
=FIXED(5000) |
5,000.00 |
=FIXED(4999, 0) |
4,999 |
=FIXED(4999, -1) |
5,000 |
=FIXED(4999, -1, TRUE) |
5000 |