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.