Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
How do I set numeric and date formats in a table in Word?
-- Susan |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
How do I set numeric and date formats in a table in Word?
That can only be done via field codes in Word. A simple example would be
this: { = 35 \# "000.00" } which would display as "035.00" in your document (assuming that your system is using the period as a decimal sign). You can read more about the formula (=) field in Word Help. -- Stefan Blom Microsoft Word MVP "Susan Sia" .(donotspam) wrote in message ... -- Susan |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
How do I set numeric and date formats in a table in Word?
It can also be done with a macro in which you can set your required formats
e.g. Sub FormatNumberAsText() Dim sNum As String sNum = Selection If sNum = "" Then Exit Sub sNum = format(sNum, "$###,###,###,###.##") Selection.TypeText sNum End Sub or as a field Sub FormatNumberAsField() Dim sNum As String sNum = Selection If sNum = "" Then Exit Sub sNum = sNum & " \# $,0.00" With Selection.Fields .Add Range:=Selection.Range, Type:=wdFieldExpression, _ Text:=sNum, _ PreserveFormatting:=False .Update End With ActiveWindow.View.ShowFieldCodes = False End Sub Select 35 and run the macro and either will enter $35.00 -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Stefan Blom wrote: That can only be done via field codes in Word. A simple example would be this: { = 35 \# "000.00" } which would display as "035.00" in your document (assuming that your system is using the period as a decimal sign). You can read more about the formula (=) field in Word Help. "Susan Sia" .(donotspam) wrote in message ... -- Susan |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge date field formats in word | Mailmerge | |||
Wrong Date formats in Word Header/Footer | Microsoft Word Help | |||
Numeric formats | Mailmerge | |||
Date formats in Word | Microsoft Word Help | |||
what are the correct date formats to use in word | New Users |