Text from number
 

What is the formula if i entered number (i.e, 5000/-) & it convert in word
(i.e, Five Thousand Only)

Text from number
 

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)