Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-18-2019, 08:25 AM
jeffreybrown jeffreybrown is offline Find & Replace to insert thousands separators Windows 10 Find & Replace to insert thousands separators Office 2016
Expert
Find & Replace to insert thousands separators
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Find & Replace to insert thousands separators Find and Replace/Insert 'CR', delete leading Spaces wherever a user Clicks in a Word document DavidL Word VBA 7 04-04-2018 12:01 AM
Find & Replace to insert thousands separators Find and Replace - How to insert brackets around all numbers in a doc Natedogg Word 2 05-21-2015 07:16 AM
Find & Replace to insert thousands separators Insert text at the end of a sentence Find/Replace AlmostFriday Word 6 06-17-2012 05:21 AM
Find & Replace to insert thousands separators Bad view when using Find and Find & Replace - Word places found string on top line paulkaye Word 4 12-06-2011 11:05 PM
Find & Replace Insert Issue mipacker Word 0 02-18-2009 08:59 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:50 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft