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)

13

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

MORE FROM ALLEN

Continuing Macro Lines

Sometimes a macro command line can get very, very long. This can make it hard to understand when you look at it a month or so ...

Discover More

Toggling AutoFilter

Want a tool that will help you toggle AutoFilter on and off? Excel provides some tools you can use, but you need to be ...

Discover More

Breaking Up Variable-Length Part Numbers

Part numbers can often be long, made up of other component elements. Breaking up part numbers into individual components is ...

Discover More

Learning Made Easy! Quickly teach yourself how to format, publish, and share your content using Word 2013. With Step by Step, you set the pace, building and practicing the skills you need, just when you need them! Check out Microsoft Word 2013 Step by Step today!

More WordTips (ribbon)

Highlighting Text Using the Keyboard Only

Highlighting text, using the Highlight tool, is a great way to mark up a document. Normally you need to use the toolbar tools ...

Discover More

Superscript and Subscript at the Same Place

Do you want a superscript and subscript character to appear directly above each other? There are multiple ways you can ...

Discover More

Accurate Font Sizes

Want to get your typeface exactly the right size? Here's how you can specify just the size you want Word to use.

Discover More
Subscribe

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

View most recent newsletter.

Comments

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 five more than 2?

2017-06-21 03:26:26

Kristjan

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

Dawn

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

TBall

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

Kyle

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


2015-05-16 07:14:49

iNfeRnO

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

jraju

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

jraju

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

Lloyd

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


2013-08-25 05:40:59

kary

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, _
PreserveFormatting:=False
Selection.TypeText Text:="=" & sAmount & " # ""0.00""" 'replace sAmount into the formula
Selection.Fields.ToggleShowCodes
Selection.Fields.Update 'refresh
End Sub


2013-08-24 16:13:10

awyatt

Kary,

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.

http://excelribbon.tips.net/T009515

-Allen


2013-08-21 11:57:52

kary

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


2013-01-09 14:12:21

awyatt

Susanne,

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.

-Allen


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
Subscribe

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.