Results 1 to 9 of 9

20030826, 11:29 #1
 Join Date
 Jan 2001
 Posts
 1,418
 Thanks
 1
 Thanked 0 Times in 0 Posts
Number Formats For Formulas (2000)
The dropdown 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

20030826, 11:36 #2
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 29 Times in 29 Posts
Re: Number Formats For Formulas (2000)
Rightclick 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 rightclick menu or by pressing F9.

20030826, 11:57 #3
 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

20030826, 12:02 #4
 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.

20030826, 12:11 #5
 Join Date
 Jan 2001
 Posts
 1,418
 Thanks
 1
 Thanked 0 Times in 0 Posts
Re: Number Formats For Formulas (2000)
Yepworks fine. 2 last questions: (1) In Excel, there is a cell in the upper lefthand corner of a spreadsheet that indicates where the curser isanything 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

20030826, 14:14 #6
 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.

20030826, 14:42 #7
 Join Date
 Jan 2001
 Posts
 1,418
 Thanks
 1
 Thanked 0 Times in 0 Posts
Re: Number Formats For Formulas (2000)
Thanks, Hans.

20030826, 16:18 #8
 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.

20030827, 03:43 #9
 Join Date
 May 2002
 Location
 Canberra, Australian Capital Territory, Australia
 Posts
 5,091
 Thanks
 2
 Thanked 426 Times in 352 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.
CheersCheers,
Paul Edstein
[MS MVP  Word]