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 ...
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.
Thank you for your very prompt reply. This is the fix I needed and it works perfectly.
Thank you again.