![]() |
#4
|
||||
|
||||
![]()
In that case, you could use code like:
Code:
Sub FormatNumbers() Dim Rng As Range, Tbl As Table, oCll As Cell, StrFmt As String With Selection If .Information(wdWithInTable) = True Then For Each oCll In .Tables(1).Range.Cells Set Rng = oCll.Range Rng.End = Rng.End - 1 If IsNumeric(Rng.Text) Then If Left(Rng.Text, 1) Like "[$€ге]" Then StrFmt = Left(Rng.Text, 1) Else StrFmt = "" End If If InStr(Rng.Text, ",") > 0 Then Rng.Text = StrFmt & Format(Round(Rng.Text, 0), "#,###") Else Rng.Text = StrFmt & Round(Rng.Text, 0) End If End If Next End If End With End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
randyflycaster | Word | 5 | 09-14-2011 07:29 AM |
![]() |
Jamal NUMAN | Word | 1 | 09-03-2011 11:37 AM |
![]() |
agorgainc | Excel | 2 | 05-12-2011 04:29 AM |
how can i make round border edges | bobafet | Word | 4 | 11-19-2009 04:40 PM |
round border egde problem(is there a better option) | bobafet | Word | 0 | 11-17-2009 11:36 AM |