Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.newusers
Pat Falango Pat Falango is offline
external usenet poster
 
Posts: 6
Default Convert Currency (USD) from Numbers to Text

I know there is a macro that does this that works in Excel. Will the same
code work in Word? Where can I find that macro?
My goal is to enter the currency amount in number format in a field in a
Word document and have it appear in text format in a second field, e.g.
$4.95 Four and 95/100 dollars.
Or would I use text boxes or table cells? Or can't this be done?


  #2   Report Post  
Posted to microsoft.public.word.newusers
Jay Freedman Jay Freedman is offline
external usenet poster
 
Posts: 9,854
Default Convert Currency (USD) from Numbers to Text

I assume you're using fields from the Forms toolbar and protecting the
document for forms.

The field for entering the number should be a text form field. In that
field's Properties dialog, give it a bookmark name, and check the box
for "Calculate on exit".

In the location where you want the words, insert a REF field from the
Insert Fields dialog. The REF field should point to the bookmark
name you gave to the text form field, and it should include a
\*DollarText switch. To do this, you'll have to click the Field Code
button in the dialog and make the code look like

REF Amount \*DollarText

In this code, the word "Amount" is the bookmark name of the text form
field. You can also add either a \*Caps switch or a \*FirstCap switch
to control the capitalization -- see the Help topic "Format (\*) field
switch" for explanations.

This will provide the spelled-out number (in your example, the "Four
and 95/100" part); you'll have to type the word "dollars" after the
REF field as plain text.

--
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.

On Mon, 25 Sep 2006 22:39:37 -0400, "Pat Falango"
wrote:

I know there is a macro that does this that works in Excel. Will the same
code work in Word? Where can I find that macro?
My goal is to enter the currency amount in number format in a field in a
Word document and have it appear in text format in a second field, e.g.
$4.95 Four and 95/100 dollars.
Or would I use text boxes or table cells? Or can't this be done?

  #3   Report Post  
Posted to microsoft.public.word.newusers
Pat Falango Pat Falango is offline
external usenet poster
 
Posts: 6
Default Convert Currency (USD) from Numbers to Text

Just what I needed. Thanks.
It took me a while to realize that the $ symbol in the REF field must be
outside the field.

Jay Freedman wrote:
I assume you're using fields from the Forms toolbar and protecting the
document for forms.

The field for entering the number should be a text form field. In that
field's Properties dialog, give it a bookmark name, and check the box
for "Calculate on exit".

In the location where you want the words, insert a REF field from the
Insert Fields dialog. The REF field should point to the bookmark
name you gave to the text form field, and it should include a
\*DollarText switch. To do this, you'll have to click the Field Code
button in the dialog and make the code look like

REF Amount \*DollarText

In this code, the word "Amount" is the bookmark name of the text form
field. You can also add either a \*Caps switch or a \*FirstCap switch
to control the capitalization -- see the Help topic "Format (\*) field
switch" for explanations.

This will provide the spelled-out number (in your example, the "Four
and 95/100" part); you'll have to type the word "dollars" after the
REF field as plain text.


I know there is a macro that does this that works in Excel. Will
the same code work in Word? Where can I find that macro?
My goal is to enter the currency amount in number format in a field
in a Word document and have it appear in text format in a second
field, e.g. $4.95 Four and 95/100 dollars.
Or would I use text boxes or table cells? Or can't this be done?



  #4   Report Post  
Posted to microsoft.public.word.newusers
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Convert Currency (USD) from Numbers to Text

If you needed four dollars and ninety-five cents instead - see
http://www.gmayor.com/formatting_wor...ounts_in_words

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Pat Falango wrote:
I know there is a macro that does this that works in Excel. Will the
same code work in Word? Where can I find that macro?
My goal is to enter the currency amount in number format in a field
in a Word document and have it appear in text format in a second
field, e.g. $4.95 Four and 95/100 dollars.
Or would I use text boxes or table cells? Or can't this be done?



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
manipulating/cutting/pasting text out of a text box [email protected] Microsoft Word Help 10 July 9th 06 10:54 PM
Wandering text box Jim K Microsoft Word Help 7 December 24th 05 12:27 AM
How do I convert automatic heading numbers to plain text? Mark_with_Questions Page Layout 2 October 25th 05 10:53 PM
Numbers to appear at the cursor... ~D~ New Users 11 February 1st 05 05:49 AM
Outline Renee Hendershott Page Layout 2 December 25th 04 03:49 PM


All times are GMT +1. The time now is 11:43 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"