format Crore in small digit

[Faruk Hosen]

Hello,
I need to format 10000000000000 to like 10,00,000 Cr

Please suggest.

 

[Chihiro]

Can you give a bit more sample? What's the condition of applying that format?
>99999 or is it something else?

 

[SirJB7]

Hi, Faruk Hosen!
Does this help?
https://superuser.com/questions/928536/how-do-you-format-numbers-in-excel-for-indian-currency-rupees
Regards!

 

[NARAYANK991]

Hi ,

I am not sure that you can divide by a crore to get the figure in units of crores.

In a format string , using an additional comma divides by 1000 ; thus a format string #,###,.### when used in a cell that contains 12345678 will display it as :

12,345.678

where the comma acts as a thousands separator , while the decimal point is because the original number has been divided by 1000.

Thus , using two commas will divide by a million. To get a figure converted to display in units of crores , you need to divide by 1 crore which is 10 million.

I am not sure that this can be done.

Narayan