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

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