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.
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:
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.
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!
Fonts, by default, come with one or more styles that define variations of how that font is displayed in your document. ...
Discover MoreSome people use quote marks around text to make it stand out. At some point you may want to treat the quoted text ...
Discover MoreWord no longer includes a Hidden tool on the ribbon as it used to in earlier versions that used toolbars. You can still add ...
Discover MoreFREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
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.
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.
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2017 Sharon Parq Associates, Inc.
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: 
Comments