How to format numbers as lakhs and crores

Hi,

I want to format numbers in the Indian formatting system with commas showing up for lakhs(1,00,000) and crores (1,00,00,000).

make one format work for both positive and negative?

Thanks..

>Go to format > format cell > select number tab > Tick right click in Decimal places > ok

Please try conditional formatting column A

=A1>=10^5 custom format ##\,##\,###

=A1>=10^7 custom format ##\,##\,##\,###

Hi Bo_Ry

Thanks for prompt help..
Your Code not working in Negative Number..

How about

=abs(A1)>=10^5

=abs(A1)>=10^7

Hi Bo_Ry

Superb....it's work perfect..Thanks
can u guide me how can it's apply in range (D3:J80) ?

Select D3:J80 Press Alt H L R or Ribbon> Home > Conditional formatting > Manage rule > New rule

Use a formula

=abs(D3)>=10^5 format > Number > custom ##\,##\,###

=abs(D3)>=10^7 format > Number > custom ##\,##\,##\,###

Hi Bo_Ry

Yes...Perfect...working fine, Thanks for help