| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unique values among duplicates without considering specific words | Excel Worksheet Functions | |||
| Convert numeric values in words. | Excel Discussion (Misc queries) | |||
| formula to add values for all the same first words in cells in a r | Excel Worksheet Functions | |||
| Assigning values to words | Excel Discussion (Misc queries) | |||
| Why do my cell values/words duplicate themselves over and over? | Excel Discussion (Misc queries) | |||
Linear Mode
