Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Columns showing $'s and cents in table
I want to make a column that shows dollars and cents especially when you want
it to automatically calculate that column at the end, this would help me immensly in a project I am trying to put together using tables. -- busyearth |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Columns showing $'s and cents in table
The simplest solution is to create the table in Excel and link it to your
document. There is no means of automatically adding dollar and cent symbols to numbers and if you add them manually, they will not calculate. You could change the number into a field eg type 32 in the table, select it then run the following macro: Sub InsertNumberAsField() Dim sNum As String sNum = Selection If sNum = "" Then Exit Sub sNum = sNum & " \# ,$0.00" With Selection.Fields .Add Range:=Selection.Range, Type:=wdFieldEmpty, _ Text:="= " & sNum, _ PreserveFormatting:=False .Update End With ActiveWindow.View.ShowFieldCodes = False End Sub which results in { = 32 \# ,$0.00 } or when toggled (which the macro applies) $32.00 You can use formulae fields to calculate fields produced in this manner. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org busyearth wrote: I want to make a column that shows dollars and cents especially when you want it to automatically calculate that column at the end, this would help me immensly in a project I am trying to put together using tables. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cents Sign | Microsoft Word Help | |||
Dollars and cents | Microsoft Word Help | |||
How can you copy TIFF images to Excel showing multiple columns. | Mailmerge | |||
mailmerge to show cents | Mailmerge | |||
Where is the currency symbol for cents? | Microsoft Word Help |