"JCP" wrote:

Hi

I need a funtion to convert Number to words literally, I mean 1241 (One Two
four one)

I found many examples for currency but I need literal every number to word.

Thanks in advance.


Vijay Chary,
India
26-11-2006

Hi JCP !,
You could write a Function or a Macro In VBA That will
Compose in words (literal) any given number in words as you have shown in
your posting.

Prepare a worksheet in the workbook with a word for each digit in one column.
(e.g.) one, two, three etc. in column A. The Macro (or Function) chooses
the contents of the nth cell in column A. Then the Words are concatenated to
give you
(e.g.) One Two Four One if you Input 1241.

You are Welcome !