Results 1 to 9 of 9
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Number Formats For Formulas (2000)

    The drop-down menu provides for a limited number of formats for results of formulas entered in table cells. Any way to expand theis offering? For example, the menu provides with respect to % formats either zero or 2 decimal places. I have a document that only calls for 1.
    Thanks,
    jeff

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Number Formats For Formulas (2000)

    Right-click a formula.
    Select Toggle Field Codes.
    You will see something like { =SUM(ABOVE) # "0.00%" }.
    The # "0.00%" is the formatting part. You can modify it to # "0.0%" idf you need one decimal place.
    Toggle field codes again, then update the field from the right-click menu or by pressing F9.

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Number Formats For Formulas (2000)

    Thanks, Hans. 2 additional questions: (1) How do I put parentheses around a negative number/% versus a "-"?, and, (2) I am having a problem in that I am editing a document and tracking my changes, and I can't seem to get your solution to work in that mode.
    Any ideas?
    Thanks again.
    Jeff

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Number Formats For Formulas (2000)

    1. You can specify up to three parts for a number format, separated by semicolons; the first is for positive numbers, the second for negative numbers and the third for zero values.

    Example: "$#,##0.00;($#,##0.00)"

    2. You will have to turn off Track Changes while modifying the number format.

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Number Formats For Formulas (2000)

    Yep-works fine. 2 last questions: (1) In Excel, there is a cell in the upper left-hand corner of a spreadsheet that indicates where the curser is-anything like that in Word to tell you where you are in a table? (2) How do you copy a formula down/accross in a table?
    Thans again.
    Jeff

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Number Formats For Formulas (2000)

    1) No, unfortunately

    2) I don't know of a way to do that. But if you need more than the occasional SUM formula, consider embedding an Excel table in your document instead of using a Word table. Excel is much more flexible and powerful if you need calculations.

  7. #7
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Number Formats For Formulas (2000)

    Thanks, Hans.

  8. #8
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Number Formats For Formulas (2000)

    Hi Jeff:
    To copy a formula down or across in Word:
    1. Copy it to the clipboard.
    2. Select the cells where you want the formula to appear.
    3. Press Ctrl+V & it will copy into all the selected cells.
    4. Press F9 to update the formula.

    This will work with simple formulas like { =SUM(LEFT) } or { =SUM(ABOVE) }. It will not "update" cell references, so if the formula in column D, row 1 is { = A1+B1 }, it won't become { = A2+B2 }, etc.

  9. #9
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Number Formats For Formulas (2000)

    Hi Jeff,

    Attached is a Word file with a simple table showing how you can set up a formula to automatically update row references when copying down (see columns D & E). I haven't yet worked out a way of doing likewise for copying across.

    Cheers
    Attached Files Attached Files
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •