View Single Post
 
Old 10-18-2019, 08:25 AM
jeffreybrown jeffreybrown is offline Windows 10 Office 2016
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default Find & Replace to insert thousands separators

I can't quite get the syntax right for replacing a number with the thousand separator.

Before
1266.89
3479.52

After
1,266.89
3,479.52

I tried
F/R with wildcard
Find: ([!/-//][0-9])([0-9]{4})(.[0-9]{2}))>
Replace: \1,\2
Reply With Quote