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