Select the cell in which the value you wish to insert the rupee symbol is entered.
Press F2 to activate cell edit mode. Press Shift + ← (Left Arrow key) to bring the cursor to the beginning of the value.
Press Alt + N + Z + S + U to display the Symbol dialog box.
Press Alt + F to select a font. Press PgDn several times to scroll and select the font you are currently using.
Press Alt + C to select character code and enter 20B9 in the input field.
Now that the rupee symbol is selected, press Alt + I to insert it.
After inserting the symbol, click Close.
The rupee symbol has been inserted. Note, however, that this rupee symbol is treated as a string.
Please send us your comments on this article.