how to convert a number in words (ex: 10 becomes "ten")

[Guest]

I wish to create a template for filling out checks where in my data sheet I
would enter the amount as a number (i.e.: 103) and it would convert to text
(i.e.: one hundred and three).

 

[Guest]

I don't know about Word, but there is a simple (free) add-in for excel called
"morefunctions" that will do exactly that, in various languages. google it
to find the download

 

[Jay Freedman]

I wish to create a template for filling out checks where in my data
sheet I would enter the amount as a number (i.e.: 103) and it would
convert to text (i.e.: one hundred and three).

In the Help topic "Format (\*) field switch" you'll find this description of
the \*CardText switch:

\*CardText
Displays results as cardinal text. The result is formatted in lowercase
letters unless you add a format switch to specify a different
capitalization. For example, { = SUM(A1:B2) \* CardText } displays "seven
hundred ninety", and { = SUM(A1:B2) \* CardText \* Caps } displays "Seven
Hundred Ninety".


You can also apply this switch to a REF field that refers to a bookmark or a
form field.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.