March 16, 2020
This is a nice work which saved lot of time for me.
I've copied code from your previous threads to convert number to words.
In excel it worked well as you described, but when I copied the same thing to access as a VB module and gave reference of calculated field in my report, it started giving error.
Can you suggest what is going wrong in access.
Secondly if you can suggest a tweak where I can hide that "No Cents" when there is no decimal in figure.
I've to convert this thing to French numbers. If you can help me in this then it will be easier for me just to translate in French.
October 5, 2010
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Excel Customer Service
November 8, 2013
If you're using the code from this page, then it should work, the only change you need is to remove Application.Trim, as that is an excel specific function.
NumToWords = Application.Trim(Units & SubUnits) should be: NumToWords = Units & SubUnits
If you don't want to display "and No Cents", replace:
SubUnits = " and No " & SubUnitName
SubUnits = ""