Now you can use the Format Painter to add the rupee sign to the rest of the values in Column C. Excel automatically formats the cell as a currency.ģ. The final result is the rupee sign inserted in cell C2, before the number. In the Symbol window, (1) choose Currency Symbols from the Subset drop-down list, (2) select the Indian Rupee Sign (₹), (3) click Insert, and (4) Cancel. Since you are inserting a currency symbol and it has to be before a number, double-click a cell to position the cursor before a number.Ģ. If you just select a cell and insert a symbol, it will automatically add it at the end of a cell’s value (in this case it would be 70₹). Double-click the cell where you want to insert the rupee sign (e.g., C2), and in the Ribbon, go to Insert > Symbol. (If you do this often, you might want to automate the insertion with a VBA loop.)ġ. In this case, you can only insert a symbol in one cell at a time, then copy the symbol to the rest of the cells in the range. Note: The rupee sign should be positioned before a number when you format a number as a currency.Īnother way to add the rupee sign is to insert it from Symbols. In the Format Cells window, (1) choose the Currency category from the right side, (2) click on the drop-down menu for Symbol, (3) select ₹ English (India), and (4) click OK.Īs a result, all values in the selected range now have the rupee symbol. (1) Select a range with numbers (here, C2:C8), and in the Ribbon, (2) go to Home and (3) click on the Number Format icon in the bottom right corner of the Number group.Ģ.
To display the rupee sign, follow these steps:ġ.
Say you have the following data set with product names in Column B and product prices in Column C.Īs you can see, numbers in Column C are prices and should be formatted as amounts in rupees. Insert the Rupee Sign Currency Number Format You can insert the rupee sign in Excel either as currency, using the number format, or by inserting a symbol.
#Indian rupee symbol how to
This tutorial demonstrates how to insert the rupee symbol in Excel and Google Sheets.
0 kommentar(er)
