| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Currency Conversion Formula
Does anyone know where I can find a formula to change a number into text,
kind of like writing a check? For example, if I type 10.71 into a field, I would like it to display, Ten and 71/100 in another field. Any suggestions. Excel 2003. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Currency Conversion Formula
See http://www.xldynamic.com/source/xld.xlFAQ0004.html
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "pantherguy" wrote in message ... Does anyone know where I can find a formula to change a number into text, kind of like writing a check? For example, if I type 10.71 into a field, I would like it to display, Ten and 71/100 in another field. Any suggestions. Excel 2003. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Currency Conversion Formula
Not entirely what you describe, but do check
http://xldynamic.com/source/xld.xlFAQ0004.html -- Kind regards, Niek Otten Microsoft MVP - Excel "pantherguy" wrote in message ... | Does anyone know where I can find a formula to change a number into text, | kind of like writing a check? For example, if I type 10.71 into a field, I | would like it to display, Ten and 71/100 in another field. Any suggestions. | Excel 2003. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value in array | Excel Worksheet Functions | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Conversion formula (Proper Case) | Excel Worksheet Functions | |||
| DIFFERENT CURRENCY FORMATS IN FORMULA | Excel Worksheet Functions | |||
| currency conversion | Excel Discussion (Misc queries) | |||
Linear Mode
