Values in words
 

Hi Matt
Below a short list for this topic:
MS Knowledge Base:
http://support.microsoft.com/default...B;EN-US;213360
http://support.microsoft.com/default...;EN-US;140704&

Free Addin MOREFUNC-DLL which includes a UDF for this task (for various
languages):
http://longre.free.fr/english/

or have a look at
http://www.bygsoftware.com/examples/...s/num2wrds.zip
It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm
It contains two methods

Frank

Matt B wrote:
Hi,

Can anyone recommend a website or know the method that will show me
how to convert a number in a cell (eg c1) into the written
representation of that number eg.

c1= 1892589.88
d1=one million eight hundred and ninety two thousand, five hundred
and
eighty nine pounds, eighty eight pence.

TIA

Matt

Values in words
 

Hi,

Can anyone recommend a website or know the method that will show me how to
convert a number in a cell (eg c1) into the written representation of that
number eg.

c1= 1892589.88
d1=one million eight hundred and ninety two thousand, five hundred and
eighty nine pounds, eighty eight pence.

TIA

Matt

Values in words
 

Thanks Frank, this is great.


Frank Kabel wrote in message
...
Hi Matt
Below a short list for this topic:
MS Knowledge Base:
http://support.microsoft.com/default...B;EN-US;213360
http://support.microsoft.com/default...;EN-US;140704&

Free Addin MOREFUNC-DLL which includes a UDF for this task (for various
languages):
http://longre.free.fr/english/

or have a look at
http://www.bygsoftware.com/examples/...s/num2wrds.zip
It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm
It contains two methods

Frank

Matt B wrote:
Hi,

Can anyone recommend a website or know the method that will show me
how to convert a number in a cell (eg c1) into the written
representation of that number eg.

c1= 1892589.88
d1=one million eight hundred and ninety two thousand, five hundred
and
eighty nine pounds, eighty eight pence.

TIA

Matt