Convert number to text for printing bank checks

New Contributor

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 Replies


See the attached sample workbook.

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

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