Custom formatting for currency

i want to format like this 'Rs.105'
what should i do...??
coz i've already tried this 'Rs.' in Custom Formatting...but didn't work....

Thank You.

Dharmik wrote:

Try this 'Rs.0' in Custom Formatting

eadameg wrote:

Thanks for suggestion....
I've already tried this one also....this custom format display like this...'Rs.105.0'
but i dont want any decimal after price ...

Dharmik,

Did you get any solution for your query?

Try this "'Rs.' . "  Please notice there is a space after 'Rs' and then a '.'

Copy the content inside double quotes and put in custom formatting.

Hope this helps.

Thanks,
Praneeth

Is Any Solution you get For display currency like Rs. 1500.00 i have tried all custom formatting which are given in this topic. i am using custom formatting: Rs#  ###,###,###.## this display currency like Rs 1500.00 i want put dot after Rs like Rs. so is any one have clue regarding it.

Finally i Got Solution for Display Currency like Rs. 1500 for that Write in custom formatting like: Rs\. ###,###.## and also select hi-IN in display local.

Rs\. 0,0.00

hello
how to display n-1 digit
7 digit > 6 digit
input: 5626111
output: 562.000 Tomans or 653.000 Tomans
thank from all

it is currect:

hello
how to display n-1 digit
7 digit > 6 digit
input: 5626111
output: 562.000 Tomans or 563.000 Tomans
thank from all