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" <Harry@discussions.microsoft.com> wrote in message
news:9E175FAE-CB97-440A-9317-7E16334F1B4C@microsoft.com...
> 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" <Harry@discussions.microsoft.com> wrote in message
news:9E175FAE-CB97-440A-9317-7E16334F1B4C@microsoft.com...
> 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" <Harry@discussions.microsoft.com>
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

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?