conversion into indian rupee

[pjcecil]

I want to convert numerical Value into indian Rupees how do I go About it.For
e.g
the numerical value of say,20 should be converted as Rs20(Rs stands for rupee)

 

[routeram]

Hi,

Select the cell(s) you want to apply currency setting to. Right clic
and choose Format cells. In the number tab select "Custom" and choos
from any of the currency types. In the "type" textbox replace the poun
symbol with "Rs" (include quotes).

Eg. a custom format type would be
"Rs. "#,##0;-"Rs. "#,##0

Hope this helps

Ra