Previous Topic Next Topic

Spellnumber for Excel

dhaf Posts 1 Registration date Sunday August 19, 2012 Status Member Last seen August 19, 2012 - Updated on Dec 22, 2018 at 04:47 PM
sgmpatnaik Posts 52 Registration date Tuesday April 2, 2013 Status Member Last seen November 27, 2013 - Apr 30, 2013 at 01:16 AM
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
Related:

1 response

Answer 1 / 1
sgmpatnaik Posts 52 Registration date Tuesday April 2, 2013 Status Member Last seen November 27, 2013 45
Apr 30, 2013 at 01:16 AM
@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
1

Similar discussions

Spell number in India Rupee
mayur -
TrowaD -

1 response
Formula in Excel to turn numbers into text
ashwin12289 -
venkatesan -

4 responses
converting number into words (Excel)
Bashir A.Zaroo -
GS -

6 responses
SPELLNUMBER VBA IN EXCEL
khamlanathphasouk -
Lan -

2 responses
Convert number to spelling
Sukumar -
mrwagh85 -

28 responses
Opening a ZIP file
Hawk40 -
Hawk40 -

8 responses