convert digit

[kalpeshpatel]

suppose i write 10,000,000 in cell B10 so automatically result shown in cell B10 is 100 lacks another exmple is suppose i write 20,00,000 so result shown as 200 thousand in cell B10

how it possible

 

[Debraj]

H Kalpesh,

I guess.. you next question will be...

"123456 and it will automatically convert to 1 Lacks, 23 Thousand and Four Hundred Fifty Six"


If not, then we will try to display above also as 12 thousand

(Instead of 123 Thousand, as per your post .. ha ha ha..)


Please confirm your next Question..


Regards,

Deb

 

[Faseeh]

Hi kalpeshpatel,


Enter following in custom cell formatting:


0.######,,


Press Control+J, and %%% It should show you 2 for 2 Lacs (200,000)... I got it from Chandoo's Post see this link:


http://chandoo.org/wp/2012/01/31/custom-number-formats-multiply-divide-by-any-power-of-10/


Some additional links:


http://exertia.wordpress.com/2006/04/23/displaying-lakhs-and-crores-in-excel/

http://www.pcreview.co.uk/forums/excel-number-format-indian-style-lacs-crores-t942185.html


Don't forget to wrap text!!


Regards,

 

[shrivallabha]

I'd guess, you want something like this:

http://www.learnexcelmacro.com/2012/04/currency-to-words/#currency_to_word

http://www.excelforum.com/excel-programming-vba-macros/373378-convert-number-to-words-indian-format.html