Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
    
You could consider embedding an Excel worksheet instead of using a table. – OmidTahouri May 18 '10 at 16:34

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"

share|improve this answer
up vote 1 down vote accepted

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.

share|improve this answer
    
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 '14 at 3:23

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

share|improve this answer
    
Yes, but no luck. Thanks. – Jason Watts May 18 '10 at 16:35
    
Crappy. :( You may be stuck copying and pasting cells to get your formatting, and then adjusting the pasted versions. – Ƭᴇcʜιᴇ007 May 18 '10 at 16:42

You must log in to answer this question.

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