software

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
[gt;9999999]quot;Rs. quot;##\,##\,##\,##0.00;[gt;99999]quot;Rs. quot;##\,##\,##0.00;quot;Rs.
quot;##,##0.00

Rupees without Paise
[gt;9999999]quot;Rs. quot;##\,##\,##\,##0;[gt;99999]quot;Rs.quot;##\,##\,##0;quot;Rs. quot;##,##0

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

QUESTIONS:
1. If the value of the cell is 0, how do I show the display as quot;Rs.
- quot;... 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
quot;Bald Eaglequot; gt; wrote in message ups.com...
gt; Experts,
gt;
gt; Intent to display:
gt; 100000 has to be displayed as Rs. 1,00,000.00
gt; 10000000 has to be displayed as Rs. 1,00,00,000.00
gt; 0 has to be displayed as Rs. -
gt;
gt; David McRitchie, Tushar Mehta and others wrote the format as given
gt; below:
gt;
gt; Rupees with Paise
gt; [gt;9999999]quot;Rs. quot;##\,##\,##\,##0.00;[gt;99999]quot;Rs. quot;##\,##\,##0.00;quot;Rs.
gt; quot;##,##0.00
gt;
gt; Rupees without Paise
gt; [gt;9999999]quot;Rs. quot;##\,##\,##\,##0;[gt;99999]quot;Rs.quot;##\,##\,##0;quot;Rs. quot;##,##0
gt;
gt; Rupees without Rs. notation
gt; [gt;9999999]##\,##\,##\,##0.00;[gt;99999]##\,##\,##0.00;##,##0.00
gt;
gt; QUESTIONS:
gt; 1. If the value of the cell is 0, how do I show the display as quot;Rs.
gt; - quot;... You know... much like how the dollar currency shows up....That's a problem because the bound checks take up all the formatting
options.gt; 2. Can I save this formula as a Custom Currency that I can later choose
gt; in a drop down?If you create it in the worksheet it will stay with the worksheet.gt; 3. I want the Rupee currency right justified as numbers usually are,
gt; but with an indent (right justified with a right margin). I DO NOT want
gt; the number to be flush with the column border...[gt;9999999]R\s\.##\,##\,##\,##0.00;[gt;99999]R\s\.##\,##\,##0.00;R\s\.####0.00