Comma separator for custom Currency (Indian Rupee)
 

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

Comma separator for custom Currency (Indian Rupee)
 

"Bald Eagle" wrote in message
ups.com...
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