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?

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?

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?

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?

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

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?