Spellnumber for Excel

Question

Hello, 
Good day to all.

I have this problem about supplying automatic spell number in writing checks. Actually, I already have seen so many ways to make it. But the ones I really need is not shown. In the place where I am right now, we dont put currency anymore because it is provide already in the check. And the word ONLY should be place at the end. Though we are using also using all capital letters on it.Is there a software I need to install.  I hope you can help me.

Thank you so much.



System Configuration: Windows 7 / Safari 535.21

sgmpatnaik · Answer

@dhaf

Hi 

Please check the below mention link for the converting Number into Text

https://ccm.net/forum/affich-694592-formula-in-excel-to-turn-numbers-into-text

from the above mention link please copy the code and paste it in normal module
after insert the code you use the formula as

say your Cheque amount is stored in D5 and you want Speellnumber in A5 will all capital letters then write the formula in A5 as

A5: =UPPER(SpellIndian(A5))

Hope it will solve your problem, other wise please inform us

Thanks

Patnaik

Spellnumber for Excel

1 response

Similar discussions

Subscribe To Our Newsletter!