I just tried the check template that can be found at the following
url.

http://groups.google.com/group/micro...a7a17efd08ce6d


http://tinyurl.com/NumberAsText


It did exactly what I needed it to do. Well, almost exactly. And of
course that's the problem.

The Function converts the following:

A1: 123.45
In B1:
=NumberAsText(A1) == One Hundred Twenty Three Point Four Five
=NumberAsText(A1,"And") == One Hundred and Twenty Three Point Four
Five
=NumberAsText(A1,"Check") == One Hundred Twenty Three and 45/100
=NumberAsText(A1,"Dollar") == One Hundred Twenty Three Dollars and
Forty Five Cents

The problem is that the format I write checks in is a combination of
the last two.

ie.

=NumberAsText(A1,"MyCheckFormat") == One Hundred Twenty Three
Dollars and 45/100

I would be grateful if someone could revise this function to have an
option of such a format.

Thanks.