View Single Post
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Carol Carol is offline
external usenet poster
 
Posts: 408
Default How do I convert a number into a text string (5 into "Five")?

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.


--
Carol A. Bratt, MCP



"Oleg" wrote:

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"