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