How to Apply the Currency Format Without Using the Toolbar in Microsoft Excel

Microsoft Excel is spreadsheet software that's part of the Microsoft Office suite that includes Word, Access and PowerPoint applications. Excel can help take a large amount of raw data and let you process, analyze and present it in a comprehensible format. If your data is in the form of dollars and cents, Excel lets you change the format of spreadsheet cells into a currency format. You can either use the toolbars to apply the currency format or the right-click function of a computer mouse.

Instructions

1. Click on a cell or select a range of cells where you want the currency format applied.

2. Right-click the cell or selection, scroll down and click the "Format Cells" option.

3. Click on the "Number" tab, then on "Currency" under the "Category" section.

4. Select the number of decimal places, currency and symbol, and how negative amounts should look under the "Sample" section.

5. Click on "OK" to apply the changes.

References

• Quantunet