How convert Numeric number in words

[Imran Murtaza]

Is there any easy formula or way to convert numeric values in words? For
example in cell A1 there is an amount 19549. How could it will be
automaticaly converted by a formula in cell B1 as Ninteen thousand five
hundred and forty-nine.
Please give me an easy answer because i am not a programmer but just an
excel user.
Imran Murtaza

 

[Jacob Skaria]

There is no direct function to convert this. For a VBA solution check out the
below links

http://www.ozgrid.com/VBA/ValueToWords.htm
http://support.microsoft.com/kb/213360
http://www.xldynamic.com/source/xld.xlFAQ0004.html

 

[Mike H]

Hi,

You might consider installing the excellent addin MOREFUNC

You can get it by Googling but here's as good a place as any

http://download.cnet.com/Morefunc/3000-2077_4-10423159.html

When installed you get a library of functions including

=NBTEXT(A1)

Which converts numbers to words
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.