How do i add the Rs symbol on my excel sheet?



2
How do i add the Rs symbol on my excel sheet? when i click on the currency format it shows only dollars, euros, pounds i can't see Rs.
Also when i use the comma it shows the number in millions format, how do i change it so that it shows in lakhs format, for example if a want the number to look like 5,45,600 instead of 545,600?

4 Answer(s)


1

Sanjay, There is some information available here on how to get the Rupee font - http://in.answers.yahoo.com/question/index?qid=20100725232137AA3y2P2

1

For changing numbers to Lakhs-

Right-click on the cells which you want to display as lakhs, and click on Format Cells, then go to the Custom category and enter the below formats:
For Lakhs (+ve and -ve):

With 2 decimals:

[>99999]##\,##\,##0.00;[<-99999.99]-##\,##\,##0.00;##,##0.00

Without decimals:

[>99999]##\,##\,##0;[<-99999.99]-##\,##\,##0;##,##0

For Lakhs and crores (+ve)

[>9999999]##\,##\,##\,##0.00;[>99999]##\,##\,##0.00;##,##0.00

For Lakhs and crores (-ve)

[<-9999999](##\,##\,##\,##0.00);[<-99999](##\,##\,##0.00);##,##0.00

0

Go to Run type fonts. Copy and paste in the folder Rupee

0

select the cell where you want to get the RS symbol and then go to the number menu in the top menu bar and select the RS symbol from there.

Your Answer

Click on this code-snippet-icon icon to add code snippet.

Upload Files (Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)

Email
Password