How do you convert numbers to real text

[Guest]

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?

 

[Rowan]

See:

http://support.microsoft.com/default.aspx?scid=kb;en-us;213360

Regards
Rowan

 

[Paul B]

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

 

[Shatin]

Check out this link:

http://www.ozgrid.com/VBA/ValueToWords.htm

 

[Ron Rosenfeld]

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

 

[Guest]

Try my NumbersToLongText Utility.

Select the cell you want to convert

http://www.geocities.com/excelmarksway/TextUtility/NumbersToLongText.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