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?

You could consider embedding an Excel worksheet instead of using a table.– OmidTahouriMay 18, 2010 at 16:34
3 Answers
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"
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.

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. Dec 2, 2014 at 3:23
Not exactly sure if it works on formulas, but have you tried Word's Format Painter?


Crappy. :( You may be stuck copying and pasting cells to get your formatting, and then adjusting the pasted versions. May 18, 2010 at 16:42