SpellNumber

G

George

Hi All,

How do I use the SpellNumber function in a cell?

i.e. - If I want cell A1 to display in words the number
in A2, how do I get A1 to display 'Three' if A2
displays '3'?

I am trying =SpellNumber(A2) but Excel does not recognise
the function.

Kind Regards,

George.
 
J

Jim

You are using the function properly. SpellNumber is an addin, available from
several sources. If you have it on your machine, Tools>Addins>see if it is
in the list and checked. If not, Tools>Addins>Browse and find it. Else
Google for a source, download it and repeat the steps to load it in the
list.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I creat userdefine function 7
Is spellnumber function no more available in MS office 2007? 2
Converting Numbers to Text 1
Displays the number in text. (One thousand two hundred thirty four 1
SpellNumber 1
how can convert the figures in to the word in excel 7
how we can use spellnumber() function in a new worksheet / file? 1
how to use spellnumber formula 3

Top