Abstract
Transcript
In this lesson we’ll take a look at the Currency format.
The Currency format is designed to display a currency symbol along with numbers.
It has options for the currency symbol itself, the number of decimal places, and negative number handling.
Let’s take a look.
Like Number format, the Currency format provides options for decimal places and handling negative numbers.
However, it does not provide an option for a thousandths separatorthis is always enabled for Currency.
Let’s set decimal places to zero, and terminate the dialog.
Like Number format, we can also adjust decimal places up and down using the buttons on the ribbon.
To display negative numbers in parentheses, we need to visit the Format Cells dialog box again.
Excel provides a huge list of options for currency symbols, including abbreviations.
One more visit to the Format Cells dialog to grab the currency symbol of None.
