Forum Discussion
Convert number to text for printing bank checks
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.
- Hans,
Thank you for your very prompt reply. This is the fix I needed and it works perfectly.
Thank you again.
