MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Written Amount


Posted by Jorge Calderon on October 18, 2001 2:27 PM

How can I obtain the written amount from a value entered in a cell? I need it for a check printing application I am working on.

Thank you very much


Posted by Juan Pablo on October 18, 2001 3:24 PM

Check one of these

http://support.microsoft.com/support/kb/articles/Q213/3/60.ASP

http://www.mrexcel.com/archive/messages/1562.html

http://geocities.com/aaronblood/pages/vba.html (#41)

I know there are many others, but i think you can solve your problem with one of these.

Juan Pablo


Posted by Don C on October 19, 2001 8:00 AM

I use a lookup table in my Excel check writer. The table goes from 0 to 99 with numbers in column A and the text for each number in column B.

A work area parses the check amount into the number for thousands, for hundreds, for units, and for cents separately. I lookup the text for each section and combine them all with "&" and the appropriate lable (thousand, hundred).

Posted by Jorge Calderón on October 19, 2001 9:01 AM

Re: Check one of these


Thanks Juan Pablo, that's just what I needed. Muchas gracias.

Posted by Jorge Calderón on October 19, 2001 9:04 AM


Thank you Don, it seems a very simple solution. I will try this also.