Menu
Ask a question Report

Spellnumber for Excel [Closed]

Posts
1
Registration date
Sunday August 19, 2012
Status
Member
Last seen
August 19, 2012
 -
Excel Ask a question Report
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
See more 

1 reply

Best answer
approved by Ratnendra Ashok on Aug 20, 2019
Report
Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
 39
1
Thank you
@dhaf

Hi

Please check the below mention link for the converting Number into Text

http://ccm.net/forum/affich-694592-numerical-to-words-convert-formula

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

Say "Thank you" 1

A few words of thanks would be greatly appreciated. Add comment

CCM 5775 users have said thank you to us this month

Ask a question