Thread: Values in words
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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