Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do you convert numbers to real text
I want to convert numbers to real text to print on checks.
1 = One 1234.50 = One Thousand Two Hundred Thirty Four & 50/100 Does anyone know how to do this? |
#2
|
|||
|
|||
See:
http://support.microsoft.com/default...b;en-us;213360 Regards Rowan Harry wrote: I want to convert numbers to real text to print on checks. 1 = One 1234.50 = One Thousand Two Hundred Thirty Four & 50/100 Does anyone know how to do this? |
#3
|
|||
|
|||
Harry, have a look here,
http://www.xldynamic.com/source/xld.xlFAQ0004.html -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Harry" wrote in message ... I want to convert numbers to real text to print on checks. 1 = One 1234.50 = One Thousand Two Hundred Thirty Four & 50/100 Does anyone know how to do this? |
#4
|
|||
|
|||
Check out this link:
http://www.ozgrid.com/VBA/ValueToWords.htm "Harry" wrote in message ... I want to convert numbers to real text to print on checks. 1 = One 1234.50 = One Thousand Two Hundred Thirty Four & 50/100 Does anyone know how to do this? |
#5
|
|||
|
|||
On Sun, 11 Sep 2005 20:23:03 -0700, "Harry"
wrote: I want to convert numbers to real text to print on checks. 1 = One 1234.50 = One Thousand Two Hundred Thirty Four & 50/100 Does anyone know how to do this? 1. Download and install Laurent Longre's free morefunc.xll from http://xcell05.free.fr/ 2. Use this formula: =NBTEXT(A1,,2)&" & "&TEXT(MOD(A1,1),"00/100") --ron |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you convert numbers to real text
Try my NumbersToLongText Utility.
Select the cell you want to convert http://www.geocities.com/excelmarksw...ToLongText.xls Can be used in any open workbook. -- Mark PS I am currently working on a conversion utility to convert Long Text to Numbers. Maybe ready in early February 2006 "Harry" wrote: I want to convert numbers to real text to print on checks. 1 = One 1234.50 = One Thousand Two Hundred Thirty Four & 50/100 Does anyone know how to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert excel file into ASCII text file with alignment? | Excel Discussion (Misc queries) | |||
convert numbers to text. | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
how do I convert copied Text numbers into values in Excel? | Excel Worksheet Functions | |||
How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) |