How convert Numeric number in words

  • Thread starter Thread starter Imran Murtaza
  • Start date Start date
I

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
 
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.
 
Back
Top