View Single Post
  #3   Report Post  
Posted to microsoft.public.word.tables
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default how do you change a number e.g 1034 to currency $10.34 in 2007?

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