Both the Currency and Accounting number formats in Excel are used to display monetary values, including the symbol for the chosen currency. However, in this article, I'll explain their subtle ...

You can also use Excel's formatting tools to automatically represent numbers as currency. To do so, highlight a cell, group of cells, row or column and click the "Home" tab in Excel's ribbon menu.