SpellNumber

I am trying to convert numbers to words. Excel help tells me:

Use the SpellNumber function in individual cells

Type the formula =SpellNumber(value) into the cell where you want to display a written number, replacing value with your number of choice.
On your keyboard, press Enter.
For example, if you type =SpellNumber(22.50), the cell should read Twenty-Two Dollars and Fifty Cents.

Tip: To convert numbers to text in a separate cell, replace the numeric value with a cell reference in the SpellNumber formula. For example, type =SpellNumber(A1) to display the written value of cell A1.

When I try it, I get a #NAME? error. I am using Excel 2016. Ideas anyone?

Silly maybe, but I assume you have the SpellNumber macro in your workbook?

See ..

https://support.microsoft.com/en-us/kb/213360

Shirley is correct. It is working perfectly.

i got a sintax error when i tried to use this code. Its on the code that says:

Cents = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & _ "00", 2))