Convert number to text for printing bank checks

[cahrensnv]

Using the SpellNumber VBA function a number such as 123.45 returns: "One Hundred Twenty Three Dollars and Forty Five Cents".

In order to be compatible with printing standard bank check formats, can the VBA function be modified so it would return: "One Hundred Twenty Three and 45/100"?

Blank bank checks already have 'Dollars" printed on the written amount line.

[#2]

@cahrensnv 

See the attached sample workbook.

The code is in Module1. You can copy this module to your own workbook in the Visual Basic Editor.

[#3]

Hans,
Thank you for your very prompt reply. This is the fix I needed and it works perfectly.
Thank you again.