![]() ![]() You can keep decimal places of the amount as per your requirement. Then from the Format Cells windows, go to Currency from the category, then select ₹ Symbol from the drop-down list which comes on clicking Symbol. Or you can also press Ctrl+1 open the Format Cells window. Then right click and click on Format cells option from the list. Then select the cells in which you want to add the currency symbol. ![]() Let’s suppose we want to add currency symbol in it. In our example we have some name of the employees and their salary in our excel sheet. That are currency formats or accounting formats.įirst let’s see how to add currency symbol applying currency format. ![]() With the help of the Format Cells feature, you can include currency symbols in your spreadsheet cells in one of two ways. Let’s go through an example to add currency with numbers step by step. To accomplish this, you must first choose the cells that you intend to format, and then apply either the Currency or Accounting number format. You will need to format the numbers so that they are compatible with currency if you wish to display them as monetary values. In this tutorial, we are going to learn about different methods to add currency symbols in excel. ![]() To the fact that different currencies have different values, it is often absolutely necessary to label values with their respective currencies. Utilizing the keyboard and the buttons on the Ribbon, creating a formula, and formatting cells are some examples of these. Excel provides a variety of options for users who wish to insert symbols into their work. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |