Custom No. Formatting

[Oh!Calcutta]

Hi Excel Bosses!

Greetings!

Could you please tell me how to format Currency figures in Millions or Billions or Lacs or Crores?

Thanks.

 

[venkat1926]

in custom format use this

##\,##\,##\,##0.00);[<-99999](##\,##\,##0.00);##,##0.00

reference:
Displaying Lakhs and Crores in Excel | exertia

 

[Oh!Calcutta]

Dear Venkat,

Thanks very much it works.

 

[Rick Rothstein]

Dear Venkat,

Thanks very much it works.

If you will ever have numbers of one billion or more, the indicated format will not work correctly. If such numbers are possible in your data, then you should find my mini-blog article here to be of use...

Excel Number Format: Indian Style Comma Separation