ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Comma separator for custom Currency (https://www.excelbanter.com/excel-discussion-misc-queries/65473-comma-separator-custom-currency.html)

Bald Eagle

Comma separator for custom Currency
 
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



All times are GMT +1. The time now is 03:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com