Translate any english number into English word
 

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

Translate any english number into English word
 

Hi,
See here

http://support.microsoft.com/default...b;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

Translate any english number into English word
 

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