Spellnumber

geeitsme · Mar 15th, 2002, 11:28 AM

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 · Mar 15th, 2002, 11:40 AM

Have a look at this:

http://support.microsoft.com/default...;EN-US;q140704

This should help you.

Mar 15th, 2002, 11:40 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Have a look at this: http://support.microsoft.com/default...;EN-US;q140704 This should help you. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 15th, 2002, 11:28 AM	#1
geeitsme Board Regular Join Date: Mar 2002 Posts: 65	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