custom currency format for Indian rupees
How to format a comma from the right of the decimal point in the third
position, then 5th then 7th ie for Indian curency for Lakhs, Crores etc |
Here is a format that you can use
[=10000000]##\,##\,##\,##0.00;[=100000]##\,##\,##0.00;##,##0.00 -- HTH RP (remove nothere from the email address if mailing direct) "seenu" wrote in message ... How to format a comma from the right of the decimal point in the third position, then 5th then 7th ie for Indian curency for Lakhs, Crores etc |
custom currency format for Indian rupees
This is not working for negative numbers. Please help
"Bob Phillips" wrote: Here is a format that you can use [=10000000]##\,##\,##\,##0.00;[=100000]##\,##\,##0.00;##,##0.00 -- HTH RP (remove nothere from the email address if mailing direct) "seenu" wrote in message ... How to format a comma from the right of the decimal point in the third position, then 5th then 7th ie for Indian curency for Lakhs, Crores etc |
All times are GMT +1. The time now is 11:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com