Spellnumber

[geeitsme]

Im having problems converting numbers to text form.

I have tried the following:

=spellnumber(a1)
=spellnumber(100.00)

I get the error message #name?

Does this require a macro?

I have tried searching the board and tips and cannot find a similar subject.

Please help

Thanks

 

[Mark O'Brien]

Have a look at this:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q140704

This should help you.