Prev: #ref
Next: Countif OR Sumproduct- I NEED HELP
From: Abhishek on 4 Mar 2010 06:07
What is the formula if i entered number (i.e, 5000/-) & it convert in word
(i.e, Five Thousand Only)
From: Mike H on 4 Mar 2010 06:14
Hi,

There are numerous bits of code available to do this but I like this Addin.
The addin is called Morefunc and as well as the function NBTEXT to convert a
number to words there are many other very useful functions.

http://xcell05.free.fr/morefunc/english/

=nbtext(a1) & " Only"

would produce the result your looking for
--
Mike

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


"Abhishek" wrote:

> What is the formula if i entered number (i.e, 5000/-) & it convert in word
> (i.e, Five Thousand Only)
 | 
Pages: 1
Prev: #ref
Next: Countif OR Sumproduct- I NEED HELP