Google Answers Logo
View Question
 
Q: formatting table in Word- currency ( Answered,   0 Comments )
Question  
Subject: formatting table in Word- currency
Category: Computers
Asked by: cbreitling-ga
List Price: $5.00
Posted: 06 Sep 2006 18:38 PDT
Expires: 06 Oct 2006 18:38 PDT
Question ID: 762863
I would like to format cells in a table in Microsoft word to
automatically show as currency.  Is this possible?  If so will you let
me know how I can do it?

Request for Question Clarification by maniac-ga on 06 Sep 2006 20:27 PDT
Hello Cbreitling,

There are a few possible solutions but I am not sure you would be
satisfied with any of these:

[1] Insert a table copied from Microsoft Excel. This would be the most
"flexible" solution where the format of values would have the same
formatting capabilities as in Excel.

[2] Create the table in Word. Create a paragraph style with "bullets"
and modify the bullet style to use the currency symbol ($) as the
"bullet". Apply that new paragraph style to every cell you want
"currency" formatting applied. Note that commas & decimals are not
automatically applied in this case - it looks somewhat OK if the data
is entered properly.

[3] Use a "formula" field to compute a value. You can specify a
numeric format (including currency formats) with this option. It can
be used to compute values (in simple ways) and may meet your needs.
After you create a table, use the menu
  Table -> Formula
& select the number format & use the cell name (row / column) as the
formula. After you do this, a value should appear which you can update
(if you do carefully - selecting the whole displayed value will remove
the formula field.

[4] The Word help on my system also refers to a "currency" format that
you should be able to access via the menu
  Format -> Style
This may work on your system (on mine - that style is not present).

Let me know if one of these solutions is acceptable and I will prepare
a proper answer.
  --Maniac

Clarification of Question by cbreitling-ga on 07 Sep 2006 20:26 PDT
This is the information that I needed.  Thank you Maniac!
Answer  
Subject: Re: formatting table in Word- currency
Answered By: maniac-ga on 09 Sep 2006 10:55 PDT
 
Hello Cbreitling,

There are several ways to format tables in Microsoft Word, but each
method has its advantages and disadvantages.

[1] Insert a table copied from Microsoft Excel. This would be the most
"flexible" solution where the format of values would have the same
formatting capabilities as in Excel. This has the disadvantage that
you must also have Excel available and the user interface is not as
"native" as a Word table (there are some additional items that appear
when the embedded table is selected).

[2] Create the table in Word. Create a paragraph style with "bullets"
and modify the bullet style to use the currency symbol ($) as the
"bullet". Apply that new paragraph style to every cell you want
"currency" formatting applied. Note that commas & decimals are not
automatically applied in this case - it looks OK only if the data is
entered properly.

[3] Use a "formula" field to compute a value. You can specify a
numeric format (including currency formats) with this option. It can
be used to compute values (in simple ways) and may meet your needs.
After you create a table, use the menu
  Table -> Formula
& select the number format & use the cell name (row / column) as the
formula. After you do this, a value should appear which you can update
(if you do carefully - selecting the whole displayed value will remove
the formula field). There is a nice example of this as well as a macro
you can use to help automate some of the steps at
  http://gregmaxey.mvps.org/Currency_Format.htm

[4] The Word help on my system also refers to a "currency" format that
you should be able to access via the menu
  Format -> Style
This may work on your system (on mine - that style is not present).

For additional information, try searching the microsoft word help with phrases like
  currency format
  table format

or search google with phrases like
  microsoft word currency format table
  microsoft word currency field

and so on. I am glad to be of help. If any part of the answer is
unclear or incomplete, please make a clarification request.

  --Maniac
Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy