Excel for Beginners (Excel Essentials Book 1) by M.L. Humphrey

Author:M.L. Humphrey [Humphrey, M.L.]
Language: eng
Format: azw3
Published: 2017-09-13T04:00:00+00:00

Currency Formatting

If you type a number into a cell in Excel, it'll just show that number. So, 25 is 25. $25 is $25. But sometimes you want those numbers to display as currency with the dollar sign and cents showing, too. Or you’ve already copied in unformatted numbers and now want them to have the same currency format.

To do this, highlight the cell(s) you want formatted this way, and then go to the Number section of the Home tab, and click on the $ sign.

Another option is to highlight the cells you want formatted that way, go to the Number section of the Home tab, and use the dropdown to choose either Currency or Accounting.

You can also highlight the cell(s), right-click, choose the Format Cells option, go to the Number tab, and choose either Currency or Accounting from there.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.