SpellNumber How to convert to " US Dollar One Hundred and 50/100

[reimar_rem]

Hi Guys,

Kindly help me to reconstruct VBA code as SpellNumber1.xlsm

VBA Code shows >>>>>> One Thousand Two Hundred Thirty Four Dollars and Fifty Cents
I want to convert it to >>>>> US Dollar One Thousand Two Hundred Thirty Four and 50/100

Kindly help me to reconstruct it.

[Solus Rankin]

Did you remove any functions from the sample workbook?

[Solus Rankin]

You can try: SpellNumber1(1).xlsm

[reimar_rem]

Hi Solus,

Is it possible to move Dollar in front line like this >> US Dollar One thousand and 50/100.

[Solus Rankin]

Amended SpellNumber1(1).xlsm

[reimar_rem]

Thanks Solus.
But I want to remove this bold dollars.
see below:

US Dollar One Thousand Two Hundred Thirty Four Dollars and 51/100

It is supposed to be:
US Dollar One Thousand Two Hundred Thirty Four and 51/100

[Solus Rankin]

With Additional changes SpellNumber1(1).xlsm

[reimar_rem]

Hi,

Thank you Solus. This is perfect!

[brcmetal]

Hello Solus,
Thank you for your post. I had same issue and now it has been settled by your post.
I have one more query need your help. In your changed SpellNumber1(1).xlsm, the output is in ProperCase, is it possible to edit code to display UPPERCASE?
Thank you in advance.

[shg]

=upper(...)

[brcmetal]

Thanks.
A little bit confusing where to input =upper (...). Convinient for you to attach Changed SpellNumber1(1).xlsm like above for easy understanding.
Thanks again.

[shg]

=upper(spellnumber(d2))

[brcmetal]

Got it! Thank you very much and have a nice day!

[shg]

You're welcome.

[brcmetal]

Sorry to disturb you once again!
Based on your guidance above, everything goes well like example given below.
USD234.56 = US DOLLARS TWO HUNDRED THIRTY FOUR AND FIFTY SIX CENTS
Now, if I need to add ONLY after the CENTS to read US DOLLARS TWO HUNDRED THIRTY FOUR AND FIFTY SIX CENTS ONLY, should I reconstruct the VBA? How to and or any way to settle this issue?