Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.word.tables
|
|||
|
|||
![]()
Thanks all for your clarification.
"Graham Mayor" wrote: {=B5*C5 \# $,0.00} has a somewhat more elegant formatting switch and will do the same job ![]() -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Pesach Shelnitz wrote: Hi, Since this question was asked in the Tables newsgroup, I would just add that the formula field mentioned by Graham can also be used within a table to display the result of a calculation on numbers in a table as well as bookmarked numbers. For example, if the number 25 appears in the second column in the fifth row (cell B5) and $41.36 appears in the thrid column in the same row (cell C5), you can display the result of multiplying these two numbers in currency format in any other cell in the table, for example, in the fourth column of the same row, by inserting the formula field {=B5*C5 \# $##,##0.00} in the cell. Note that you do not type the curly brackets ({}) for field codes. Instead, select whatever is to be enclosed by them, press Ctrl+F9, and then press F9. The formula field is actually documented in the Word 2007 online help at http://office.microsoft.com/en-us/wo...387981033.aspx. It depends where the number has come from. There is no way to automatically format typed numbers as currency on the fly in any Word version. You would need a field e.g. to turn 1034 into $10.34 you would need a calculation field { =1034 / 100 \# "$,0.00" }. If you need typed numbers formatted as currency then it is quicker simply to type them as such. or you could select the number and use a macro - in this instance Dim rNum As Range Set rNum = Selection.Range If IsNumeric(rNum.Text) = False Then MsgBox "No number selected", vbInformation, "Error" Exit Sub End If rNum.Fields.Add rNum, wdFieldExpression, rNum.Text & " /100 \# $,0.00", False http://www.gmayor.com/installing_macro.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Help with Word 2007 wrote: I have searched high and low in the useless Microsoft online help in 2007 for basic formatting functionality that appears to be very well hidden. Can someone please let me know if they have found any, eg commas, numbers into currency, etc. thanks . . |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Currency / Number Formating Issue | Mailmerge | |||
How do I change the cell format to currency without a formula? | Microsoft Word Help | |||
Change Multilevel List Number Style in Word 2007 | Page Layout | |||
How do I use field codes to format a number into currency? | Mailmerge | |||
Currency fields in Access lose th currency format whn merged why | Mailmerge |