How do I convert a number into a text string (5 into "Five")?

[Guest]

Is there a way in Word or Excel to automatically convert a number into a text
string? For example: 1945.00 into "One Thousand Nine Hundred Forty Five"

 

[Guest]

Try this:

Select the cells you want to convert.
Choose Cells from the Format menu. Excel displays the Format Cells dialog
box.
Make sure the Number tab is selected.
In the list of formatting Categories, choose Text.
Click on OK.
Press Ctrl+C. This copies the cells you selected in step 1.
Choose Paste Special from the Edit menu. Excel displays the Paste Special
dialog box.
Choose the Values radio button.
Click on OK.
Another thing you can do is to use the TEXT worksheet function. Let's say
you have the value 789 in cell A7. In cell B7 you could place the following:

=TEXT(A1, "#,##0.00")
This usage of TEXT results in a text digits that have the thousands
separator in the right place and two digits to the right of the decimal
point, as in "6,789.00". You can specify, as the second parameter to TEXT,
any formatting desired. If you want the number converted to text without any
special formatting, you can use the following:

=TEXT(A1, "0")
The result is the textual equivalent of an integer value.

 

[Jay Freedman]

You can use the \*CardText switch in many types of field. Look in the Help
for the topic "Format (\*) field switch" to see the rules.

For example, if you have the number 1945.00 somewhere in the text and you
insert a bookmark named Amount that covers it, then this field

{ Ref Amount \*CardText }

will display the text "one thousand nine hundred forty-five" and the field

{ Ref Amount \*CardText \*Caps }

will display the text "One Thousand Nine Hundred Forty-Five".

Other kinds of fields (such as =SUM) will behave the same way.

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

 

[Suzanne S. Barnhill]

In Word, if the number is the result of a field, you can add the \*Cardtext
switch to it.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.