correction...
by default expected as

1,000 1 Thousand 1,000
100,000 1 Lakh (100 Thousand) 1,00,000
10,000,000 1 Crore (100 Lakh) 1,00,00,000


--
Dr. Sachin Wagh
MBBS, DHA, DPH


"Dr. Sachin Wagh" wrote:

We have a system of Calculating Money in Lakhs & Crores, unlike Millions &
Billions. The Commas inevitablly confuse, can we have a system as follows€¦

by default expected as

1,000 1 Thousand 1,000
100,000 1 Lakh (100 Thousand) 1,00,000
10,000,000 1 Lakh (100 Lakh) 1,00,00,000

##,###,##0 custom format does not work

Thanking you in Anticipation

--
Dr. Sachin Wagh
MBBS, DHA, DPH