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