Home » Blog » How to add thousand separator to numbers in Word document?

Blog

How to add thousand separator to numbers in Word document?

AdminP p

January 3, 2024

112 Views 0

SaveSavedRemoved 0

To add a thousand separators to numbers in a Word document, you can use different methods. Here are some tricks on handling this task in Word:

Add Thousand Separator with Shortcuts:

1. Place the cursor at the location where you want to insert the thousand separator.
2. Press the Alt key and type 044 using the number keyboard.

Add Thousand Separator with Symbol:

1. Place the cursor where you want to insert the thousand separator.
   

   How to add thousand separator to numbers in Word document

2. Go to Insert > Symbol > More Symbols.
3. In the Symbol dialog, select “Verdana” from the Font drop-down list and “Basic Latin” from the Subset drop-down list.
4. Choose the thousand separator from the list and click Insert.

Add Thousand Separator with VBA:

1. Select the number you want to insert thousand separators into.
2. Press Alt + F11 to open the Visual Basic for Applications (VBA) window.
3. Click Insert > Module and copy and paste the provided VBA code into the module.

Sub AddCommasToNumbers()
Dim xWarp As Integer
If Selection.Type = wdSelectionIP Then
ActiveDocument.Range(0, 0).Select
xWarp = wdFindContinue
Else
xWarp = wdFindStop
End If
With Selection.Find
.ClearFormatting
.Text = “[0-9]{4,}”
.Replacement.Text = “”
.Forward = True
.Wrap = xWarp
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchAllWordForms = False
.MatchSoundsLike = False
.MatchWildcards = True
Do While .Execute
Selection.Text = Format$(Selection.Text, “#,##0”)
If xWarp = wdFindContinue Then
Selection.Collapse wdCollapseEnd
Else
Exit Sub
End If
Loop
End With
End Sub

Press F5 to run the code. Thousand separators will be inserted into the selected number.

These methods allow you to insert thousand separators either manually, symbolically, or by using VBA code depending on your specific requirements.