Page 74 - Ms Excel Note and Workbook
P. 74
MICROSOFT EXCEL NOTE AND WORKBOOK
a value with currency formatting in a formula, the calculated value will also use the
currency number format.
• If you want your data to appear exactly as entered, you'll need to use the text number
format. This format is especially good for numbers you don't want to perform calculations
with, such as phone numbers, zip codes, or numbers that begin with 0, like 02415. For
best results, you may want to apply the text number format before entering data into
these cells.
Increase and Decrease Decimal
The Increase Decimal and Decrease Decimal commands allow you to control how many decimal
places are displayed in a cell. These commands don't change the value of the cell; instead, they
display the value to a set number of decimal places.
Decreasing the decimal will display the value rounded to that decimal place, but the actual value
in the cell will still be displayed in the formula bar.
The Increase/Decrease Decimal commands don't work with some number formats,
like Date and Fraction.
65 | P a g e
