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)

When I use my formula's it comes up #NAME?

Hi,

I wrote this code

https://www.myonlinetraininghub.com/convert-numbers-currency-to-words-with-excel-vba

Is this what you are using?

Can you please attach your workbook with the code.

Regards

Phil

Yes that is were I found it 

See attached 

THanks

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