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

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

--
Jacob


"Imran Murtaza" wrote:

> 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

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/30...-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.


"Imran Murtaza" wrote:

> 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