Currency conversion

[syam]

hi

i have a problem with the currency format in excel. in india we use the lakhs and crores system as follows:

100,000 is written as 1,00,000 (i.e. 1 lakh)
1,000,000 is written as 10,00,000 (i.e. 10 lakhs)
10,000,000 is written as 1,00,00,000 (i.e. 1 crore)
100,000,000 is written as 10,00,00,000 (i.e. 10 crores)

i am wondering if it may be possible to implement the indian currency format in excel 2007?

regards
syam

 

[Faseeh]

Please go through this:

http://chandoo.org/wp/2010/07/26/indian-currency-format-excel/

 

[Dayanand]

Hi syam,

Use this format and do changes accordingly.

[>=1000000]0.0,," Mn";[>=1000]0.0," K"