1

When I apply a formula to the table, it allows me to select a format. How do I apply a currency format on the numbers to the other cells in Word 2007?

Improve this question
1
  • You could consider embedding an Excel worksheet instead of using a table.
    – OmidTahouri
    May 18, 2010 at 16:34

3 Answers 3

Reset to default
1

If you're dealing with numbers and currency, it may be worth using an Excel worksheet embedded in to the Word document.

Insert > Object > "Microsoft Office Excel Worksheet"

Improve this answer
1

Turns out if you insert a formula and just use = 15000 instead of =sum(ABOVE), it gives the results I was looking for.

I know I could have inserted an Excel spreadsheet, but I had so many tables that were already styled and didn't want to redo the work.

For clarity, to be able to insert a formula into a Word document you must be inside a table. Using the Table Tools - Layout ribbon section there is the Formula button near the AZ Sort button.

Improve this answer
1
  • This worked great, only downside to this, it does not seem like Word can auto sum a column that you do this to properly. At the very least it can't autosum if you use a number format where negative is displayed as ($100.00). I did the autosum then applied this to the cells afterwards, so it worked alright.
    – Chris Marisic
    Dec 2, 2014 at 3:23
0

Not exactly sure if it works on formulas, but have you tried Word's Format Painter?

Improve this answer
1
  • Crappy. :( You may be stuck copying and pasting cells to get your formatting, and then adjusting the pasted versions.
    – Ƭᴇcʜιᴇ007
    May 18, 2010 at 16:42

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .