Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

3 Answers 3

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 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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.