Translate any english number into English word

  • Follow


I am a beginner. it may be a silly question. 

In excel, suppose in one cell a number is appearing as 9. I want to write in 
another cell as "Nine".

How it will be possible?

SANTANU
0
Reply Utf 3/4/2010 4:13:02 PM

Hi,
See here

    http://support.microsoft.com/default.aspx?scid=kb;en-us;213360
        'How to convert a numeric value into English words in Excel'


"SANTANU" wrote:

> I am a beginner. it may be a silly question. 
> 
> In excel, suppose in one cell a number is appearing as 9. I want to write in 
> another cell as "Nine".
> 
> How it will be possible?
> 
> SANTANU
0
Reply Utf 3/4/2010 4:29:01 PM


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/

-- 
Mike

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


"SANTANU" wrote:

> I am a beginner. it may be a silly question. 
> 
> In excel, suppose in one cell a number is appearing as 9. I want to write in 
> another cell as "Nine".
> 
> How it will be possible?
> 
> SANTANU
0
Reply Utf 3/4/2010 4:42:05 PM

2 Replies
591 Views

(page loaded in 0.067 seconds)

Similiar Articles:
















7/20/2012 5:20:06 PM


Reply: