Please Note: This article is written for users of the following Microsoft Word versions: 2007 and 2010. If you are using an earlier version (Word 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Word, click here: Formatting Currency.

Formatting Currency

by Allen Wyatt
(last updated April 16, 2015)


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.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (11331) applies to Microsoft Word 2007 and 2010. You can find a version of this tip for the older menu interface of Word here: Formatting Currency.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...


Plotting Times of Day

Got a chart created from your worksheet? You can plot times of day in the chart if you apply the simple techniques in ...

Discover More

Vertically Centering Labels

Want the text printed on your labels to be centered vertically? It's not that hard, and this tip shows the easiest method.

Discover More

Modifying the Color Scheme

Windows maintains what it calls a color scheme to control how the various elements of Windows appear. Here's how to ...

Discover More

Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!

More WordTips (ribbon)

Adjusting the Width of Characters

Need to adjust how your characters look horizontally? Word provides an easy way you can scale the horizontal appearance ...

Discover More

Reversed Bolding

If you paste information from one document into another, you may be surprised at the results. If your text changes from ...

Discover More

Adjusting Small Caps Text

If you use small caps text in a document, you know that there are several steps involved in properly formatting the text. ...

Discover More

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.


If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is one minus 1?

2017-06-21 03:26:26


When I use the decimal separator as the thousand separator, then no matter how long the number is, it all goes before the comma, e.g. my number format is £#,##0 and the value is 1500 then it will become £1500, 0 (the desired result should be £1,500). This works fine with space as the separator (# ##0 € is displayed as 1 500 €, not 1500 €).

Is there a way to override this without changing the regional settings? Or maybe I've made a mistake? Any help would be greatly appreciated. Thanks!

2016-02-09 16:14:40


You should add that you can convert an existing unformatted value to a field by selecting the value and pressing Control F9. You then add the equal sign and the formatting codes (which can be copied and pasted.) much quicker than re-entering all the values.

2016-01-06 15:48:35


This has not helped me in that after the above is followed exactly, I end up with a blank field. I discovered I can then highlight that field with the "fx formula" button and change the dollar amount, but the numbers will not add up when I use the "sum above" formula in the last row of the column.

2015-06-25 16:42:43


Does this work in a Word Form field? If not, how do you adjust for that?

2015-05-16 07:14:49


Hey, sorry to be a bother. What would a macro to convert all numbers in a document to currency format look like?

2014-03-30 10:19:20


Hi, I have succeeded in getting the dollar sign in one cell of the word table. Update this field only update that cell. Should we have to repeat this procedure for every cell.
Oh, will it not be easy if you prefer a rare used key[ to autocorrect option to get easy the dollar symbol, by inserting dollar symbol from windig font or other vrinda font. How it is a tip, if it could not do automation. Atleast by this shift use for dollar sign could be avoided.

2014-03-30 08:07:30


Hi, 1 to 6 instructions are clear . But where to start after ctrl f9. Should we type in between these braces. Where to type the $,000 Please if you give a screen shot , it will be very useful. Hope to get the reply to this post

2014-02-24 13:36:02


Cannot find anything on how to convert to currency when merging Excel documents with Word 2007?

2013-08-25 05:40:59


Thank you for your help. It works and my code is as follows in case anyone else needs it.

sPrompt = "Please enter amount" 'input box to receive amount
sTitle = "Amount"
sDefault = 0
sAmount = InputBox(sPrompt, sTitle, sDefault) 'stored in sAmount

Selection.Fields.Add Range:=Selection.Range, Type:=wdFieldEmpty, _
Selection.TypeText Text:="=" & sAmount & " # ""0.00""" 'replace sAmount into the formula
Selection.Fields.Update 'refresh
End Sub

2013-08-24 16:13:10



You can't. (That's the short answer.) There is a tip over on the ExcelTips site that is applicable to your question; the concepts discussed there also apply to using VBA in Word.


2013-08-21 11:57:52


Hi, How can I pause the macro so that number entry can occur?

2013-01-09 14:12:21



It may very well be that some tips are done exactly the same regardless of which version of Word you are using. This happens to be one of those.

Since you are using Word 2007, all you need to do is follow the steps listed on this page.


2013-01-09 13:43:31

Susanne Lauber

I'm reviewing your Formatting Currency Tips #1773 and #11331 and I'm not seeing any difference between the two. Tip #1773 is supposed to be for some Word versions prior to 2007 and Tip #11331 is supposed to be for versions 2007 and 2010. Am I missing something here? I'm interested in how to format currency in a table cell in version 2007.

This Site

Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.

Newest Tips

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.