bottom
Great WordTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > WordTips Home > Formatting > Formatting Tables > Formatting Currency

Formatting Currency

Summary: If you need to format a number so that it appears as currency, it is not as easy to do in Word as it is in Excel. You can use the technique introduced in this tip (utilizing fields) to control exactly how you want that number displayed. (This tip works with Microsoft Word 97, Word 2000, Word 2002, Word 2003, and Word 2007.)

Those who are familiar with the rich formatting features of Excel may long for a way to format numbers in a Word table just as easily. For instance, you may have a column of numbers that you want to format as currency, complete with the dollar sign. Unfortunately, Word does not allow you to do this type of formatting directly.

There is a work-around, however. You can use a field to insert any number you want in any format you want. For instance, let's say you have the number 65.78, and you want it formatted as currency in a particular table cell. All you need to do is follow these steps:

  1. Position the insertion point in the table cell where the number will reside.
  2. Press Ctrl+F9 to insert a pair of field braces.
  3. Type the equal sign, followed by the number (65.78).
  4. Type a space, followed by \# and another space. This switch tells Word that you are about to specify the format for the number.
  5. Enter the format specification, in quote marks. In this case, you would enter "$#,###.00".
  6. Press Shift+F9 to collapse the completed field.

You can continue to insert numbers in this way. If you have quite a few of them, you may want to create a macro to automate the process. Entering numbers in this way will not affect your ability to create column totals, as well.

Tip #1773 applies to Microsoft Word versions: 97 | 2000 | 2002 | 2003 | 2007


Step Up and Take Control! Subscribers to WordTips know just how valuable a resource it is. WordTips Premium provides twice the number of exceptional, easy-to-understand tips every week in an ad-free newsletter, as well as substantial discounts on WordTips archives and e-books.
 
Check out WordTips Premium today!

Helpful Links

Ask a Word Question
Make a Comment

Tips.Net Home
Tips.Net Store

WordTips FAQ
WordTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
WordTips Site

 

Great Info!

Get tips like this every week in WordTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)