Currency vs Accounting Format in Excel Display Negative Numbers | Financial Statement Style Both Currency and Accounting styles are formatting styles that Excel uses to display numbers in cells. To understand the difference between currency vs accounting format in Excel, let’s take a look at the examples below. Currency vs Accounting Format 1. Select the … Read more

Display Numbers as Fractions in Excel To learn how to display numbers as fractions in an Excel cell and how to change the format of a fraction, follow the steps below. 1. Select cell C3 and type either 2 3/8 or 0 3/8 as a mixed fraction. Note that excel changed the cell’s format in … Read more

Decimal Places in Excel In this lesson, we are going to learn how to increase or decrease decimal places without changing the actual number in the cell. 1. Enter 25.89 in cell C3. 2. Select C3. 3. Click “Decrease Decimal” on the Home tab. Note: The number in cell C3 is now showing one less … Read more