The Great Crypto Escape's video: How To Format Excel Cells As Currency Tutorial Format numbers as currency in Excel

Learn How To Format Excel Cells As Currency Tutorial and Format numbers as currency in Excel in this Excel Currency Formatting Tutorial. It is important to be able to format Excel data correctly for a number of reasons like automation, readability, and so Excel understands the type of data it is dealing with. Some of the advice provided by Microsoft Support https://support.microsoft.com/en-us/office/format-numbers-as-currency-in-excel-for-the-web-504781f6-9617-44f8-852a-62e363d96a98 is: To show numbers as currency, you can apply either the Currency format or the Accounting format. (You'll find a comparison of the two formats in the Currency or Accounting section, below.) Select the cells that you want to format and then, in the Number group on the Home tab, click the down arrow in the Number Format box. Choose either Currency or Accounting. Number format drop-down screen Excel for the web applies the default currency symbol and appropriate decimal places in the cells that you selected. Currency or Accounting? While both the Currency format and the Accounting format can be used to correctly display monetary values, there are some differences between them, as shown in the following table. Format Description Example Currency With this format: The decimal points appear aligned in the column. The currency symbol appears next to the first digit in the cell. (That is, it is not aligned with the other currency symbols in the column. Currency number format applied to cells Accounting With this format: Both the currency symbols and the decimal points appear aligned in the column. Cells that contain only zeros are identified with a hyphen. Negative numbers appear in parentheses. Accounting number format applied to cells Change the default currency symbol You can’t change the default dollar currency symbol in Excel for the web just yet; but if you have the Excel desktop application, you can click Open in Excel and follow the instructions here to specify the default currency symbol that you want. After you apply the currency symbol, save your worksheet and then reopen it in Excel for the web. All this information is taken from Microsoft support 2021 at the address: https://support.microsoft.com/en-us/office/format-numbers-as-currency-in-excel-for-the-web-504781f6-9617-44f8-852a-62e363d96a98 Checkout that website for more details. *********************************************************************** *********************************************************************** * If you purchase anything through a link in this video, you should assume that I have an affiliate relationship with the company providing the product or service that you purchase, and that I'll be compensated in some small way at no extra cost to you.