Comma separator for custom Currency (Indian Rupee)

[Bald Eagle]

Experts,

Intent to display:
100000 has to be displayed as Rs. 1,00,000.00
10000000 has to be displayed as Rs. 1,00,00,000.00
0 has to be displayed as Rs. -

David McRitchie, Tushar Mehta and others wrote the format as given
below:

Rupees with Paise
[>9999999]"Rs. "##\,##\,##\,##0.00;[>99999]"Rs. "##\,##\,##0.00;"Rs.
"##,##0.00

Rupees without Paise
[>9999999]"Rs. "##\,##\,##\,##0;[>99999]"Rs."##\,##\,##0;"Rs. "##,##0

Rupees without Rs. notation
[>9999999]##\,##\,##\,##0.00;[>99999]##\,##\,##0.00;##,##0.00

QUESTIONS:
1. If the value of the cell is 0, how do I show the display as "Rs.
- "... You know... much like how the dollar currency shows up....
2. Can I save this formula as a Custom Currency that I can later choose
in a drop down?
3. I want the Rupee currency right justified as numbers usually are,
but with an indent (right justified with a right margin). I DO NOT want
the number to be flush with the column border...

Thanks in advance
Bald Eagle

[Bob Phillips]

"Bald Eagle" <[email protected]> wrote in message
news:[email protected]...
> Experts,
>
> Intent to display:
> 100000 has to be displayed as Rs. 1,00,000.00
> 10000000 has to be displayed as Rs. 1,00,00,000.00
> 0 has to be displayed as Rs. -
>
> David McRitchie, Tushar Mehta and others wrote the format as given
> below:
>
> Rupees with Paise
> [>9999999]"Rs. "##\,##\,##\,##0.00;[>99999]"Rs. "##\,##\,##0.00;"Rs.
> "##,##0.00
>
> Rupees without Paise
> [>9999999]"Rs. "##\,##\,##\,##0;[>99999]"Rs."##\,##\,##0;"Rs. "##,##0
>
> Rupees without Rs. notation
> [>9999999]##\,##\,##\,##0.00;[>99999]##\,##\,##0.00;##,##0.00
>
> QUESTIONS:
> 1. If the value of the cell is 0, how do I show the display as "Rs.
> - "... You know... much like how the dollar currency shows up....


That's a problem because the bound checks take up all the formatting
options.


> 2. Can I save this formula as a Custom Currency that I can later choose
> in a drop down?


If you create it in the worksheet it will stay with the worksheet.


> 3. I want the Rupee currency right justified as numbers usually are,
> but with an indent (right justified with a right margin). I DO NOT want
> the number to be flush with the column border...


[>9999999]R\s\.##\,##\,##\,##0.00;[>99999]R\s\.##\,##\,##0.00;R\s\.####0.00