Menu
  1. Accueil
  2. Forum
  3. Office Software
  4. Excel

Spellnumber for Excel [Closed]

Report
Posts
1
Registration date
Sunday August 19, 2012
Status
Member
Last seen
August 19, 2012
 -
sgmpatnaik
Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
 -
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

Answer 1 / 1
Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
 41
@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
Thank you
1
Thank you

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

CCM 4139 users have said thank you to us this month

Ask a question