Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Oleg Oleg is offline
external usenet poster
 
Posts: 1
Default How do I convert a number into a text string (5 into "Five")?

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"
  #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"

  #3   Report Post  
Posted to microsoft.public.word.docmanagement
Jay Freedman Jay Freedman is offline
external usenet poster
 
Posts: 9,854
Default How do I convert a number into a text string (5 into "Five")?

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 FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

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"



  #4   Report Post  
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default How do I convert a number into a text string (5 into "Five")?

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
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Oleg" wrote in message
...
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"


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Header with picture or text box Scott Page Layout 15 April 28th 23 02:52 AM
manipulating/cutting/pasting text out of a text box [email protected] Microsoft Word Help 10 July 9th 06 10:54 PM
How do I get rid of a page number on a Save As\ Text Only doc? Mike Whitehurst Microsoft Word Help 2 March 24th 05 02:17 PM
Any way to link text with Figure or Table number? Richard Stanford Microsoft Word Help 1 January 4th 05 03:32 PM
Outline Renee Hendershott Page Layout 2 December 25th 04 03:49 PM


All times are GMT +1. The time now is 07:22 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"