Posted to microsoft.public.excel.misc
|
|
Custom Format for Numbers
See this link (maybe wrapped)
http://groups.google.com/group/micro...212e16183e1a4c
--
Kind regards,
Niek Otten
"Dr. Sachin Wagh" wrote in message
...
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
|