Log In
Register
Home
July 10, 2019
Offline
Using Excel Version 2016
Either of these formulas do not seam to work.
=NumToWords(234)
=NumToWords(A2)
Is there another formula to use?
Thanks
Trusted Members
December 20, 2019
Offline
I dont think that NumToWords is a proper excel formula - i seem to remember seeing a video where someone created a massive fomula to convert numbers to words and another where someone created VBA to do it (which is probally where you got the NumToWords from)
July 10, 2019
Offline
When I use my formula's it comes up #NAME?
October 5, 2010
Offline
Hi,
I wrote this code
https://www.myonlinetraininghu.....-excel-vba
Is this what you are using?
Can you please attach your workbook with the code.
Regards
Phil
July 10, 2019
Offline
Yes that is were I found it
See attached
THanks
October 5, 2010
Offline
Hi,
The file you attached is an XLSX so it can't store VBA. You need to save the file as an XLSM to store and run VBA.
Try opening the workbook from my blog post again and saving that for your use.
You can open the VBA editor (ALT+F11) to see the VBA code in the workbook.
Regards
Phil
1 Guest(s)
