The Currency and Accounting format in Excel

Feb 03, 2020 • edited Feb 04, 2020

The Currency and Accounting format in Excel

The Currency format and the Accounting format in Excel are very similar to each other. This example shows the difference.

we’ll learn the difference between currency and accounting in Microsoft Excel. Though both are very similar to each other but still there are few differences in between both formatting.

This tutorial explains you the differences between Currency & Accounting format in Excel.

1. Enter the following values.

2. The Currency format places the dollar sign right next to the number.

3. The Accounting format aligns the dollar signs at the left edge of the cell and displays a dash for zero values.

Note: the Currency format can display negative numbers with a minus sign, in red, with parentheses, or in red with parentheses. The Accounting format displays negative numbers in parentheses.

#Tutorial#Tips#Format Cells

How to convert text strings that represent numbers to numbers

How To Enter A Fraction And Change The Format Of A Fraction In Excel