Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to convert numbers to text (e.g 10 = Ten)
I want to convert numbers to words in Microsoft excel e.g 10 = Ten where
suppose 10 is in A1 and Ten should come automatically in B1 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to convert numbers to text (e.g 10 = Ten)
http://xldynamic.com/source/xld.xlFAQ0004.html
-- Kind regards, Niek Otten Microsoft MVP - Excel "Jeff" wrote in message ... |I want to convert numbers to words in Microsoft excel e.g 10 = Ten where | suppose 10 is in A1 and Ten should come automatically in B1 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to convert numbers to text (e.g 10 = Ten)
Perhaps,
http://xldynamic.com:80/source/xld.xlFAQ0004.html HTH, -- Kevin James. Tua'r Goleuni "Jeff" wrote in message ... |I want to convert numbers to words in Microsoft excel e.g 10 = Ten where | suppose 10 is in A1 and Ten should come automatically in B1 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to convert numbers to text (e.g 10 = Ten)
This file might be a help:
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 the "SPELLNUMBER" function, which can be used in your spreadsheets, two methods to convert numbers to words and two cheque writing routines. -- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - "Jeff" wrote in message ... I want to convert numbers to words in Microsoft excel e.g 10 = Ten where suppose 10 is in A1 and Ten should come automatically in B1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert numbers to text | Excel Discussion (Misc queries) | |||
How do I convert text to numbers in an old version of excel | Excel Worksheet Functions | |||
convert text to numbers | Excel Discussion (Misc queries) | |||
How do I convert numbers to text like bahttext but in sterling | Excel Worksheet Functions | |||
Convert text to numbers | Excel Discussion (Misc queries) |