Adding currency in a Word document

Anonymous
2023-01-08T20:28:30+00:00

How do I insert a table in a Word document - that can be used to total currency automatically?

I know how to insert the table, but I want to format it to automatically calculate a column of dollars

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} votes

4 answers

Sort by: Most helpful
  1. triptotokyo-5840 36,676 Reputation points Volunteer Moderator
    2023-01-08T20:52:28+00:00

    but I want to format it to automatically calculate a column of dollars

    You need to tell us please what you want the calculation to do so for example do you want to add amounts in columns 1 and 2 and put the result(s) in column 3?

    1 person found this answer helpful.
    0 comments No comments
  2. Anonymous
    2023-01-08T21:05:01+00:00

    I want one column

    Enter dollar amounts (+ and or - dollars)

    $10,000.00 Amount
    $500.00 Plus
    $100.00 Plus
    $4,000.00 Minus
    $6,600.00 TOTAL
    0 comments No comments
  3. Jay Freedman 205.9K Reputation points Volunteer Moderator
    2023-01-08T21:21:14+00:00

    In the table that contains the column of dollar amounts, create another row at the bottom of the table. In the cell of that row that's in the same column as the amounts, go to the Layout tab of the ribbon at the far right (NOT the Layout tab to the left of the References tab) and click the Formula button to open the Formula dialog.

    Image

    The Formula box in the dialog should default to = SUM(ABOVE) but you can enter that if it defaults to something else. Normally the formula will format the result the same as the entries in the column, but you can pick the dollar format from the dropdown of the Number format box if need be. Click OK. The resulting sum will appear where the cursor was:

    Image

    A few things to note about this:

    • If you change, add, or remove any of the numbers in the column, update the field by clicking on it and pressing F9, or right-clicking it and choosing Update Field.
    • The ABOVE part of the formula stops working its way up the column if it finds a blank cell, leading to a wrong result:

    Image

    • To see the formula in the field, click in the field and press Shift+F9 (on some laptops, hold the Fn key while pressing Shift+F9) or right-click the field and click Toggle Field Codes. To return to the result, repeat the same action.
    • In a table of dollar amounts, it's a good idea to select the whole column and insert a decimal tab stop to make the numbers align on the decimal point. See http://wordfaqs.ssbarnhill.com/SettingTabs.htm

    Form more information about table formulas, see https://support.microsoft.com/en-us/office/use-a-formula-in-a-word-or-outlook-table-cbd0596e-ea8a-485e-a35d-b2cb2c4f3e27

    5 people found this answer helpful.
    0 comments No comments
  4. triptotokyo-5840 36,676 Reputation points Volunteer Moderator
    2023-01-08T21:41:39+00:00

    I want one column

    Enter dollar amounts (+ and or - dollars)

    $10,000.00 Amount
    $500.00 Plus
    $100.00 Plus
    $4,000.00 Minus
    $6,600.00 TOTAL

    I’ve just put up a file for you at:-

    https://www.mediafire.com/file/3e8rykexro1h2n3/Adding_currency_in_a_Word_document_FILE_FOR_user.DOCX/file

     - which shows you one way in which it might be done.

    Download the file and open it clicking:-

    Enable Editing

     - if necessary.

    Go to page 4 of 4 where you can see the image below.

    Does that give you what you want?

    PS - you may find this helpful:-

    Use a formula in a Word or Outlook table - Word for Microsoft 365

    Image

    2 people found this answer helpful.
    0 comments No comments