Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-17-2018, 09:55 AM
Ulodesk Ulodesk is offline Adding a symbol to numbers in a table Windows 7 64bit Adding a symbol to numbers in a table Office 2013
Word 2013 Expert Cert
Adding a symbol to numbers in a table
 
Join Date: Sep 2009
Location: Virginia
Posts: 872
Ulodesk is on a distinguished road
Default Adding a symbol to numbers in a table

Yesterday I was faced with the challenge of adding a dollar sign to all the number amounts in several columns of a several-page-long table. First, I figured out how to use wild cards to do it for any number of 2 or 3 places. (All numbers had 2 digital places, but this seemed irrelevant to me purpose.) However, while perhaps a dozen of the numbers were only three places, e.g., 306.54, most of them were in the thousands or ten-thousands, with a comma. I found that my search formula then jumped to the hundreds places, e.g., 13,576. Then I determined how to change the search to look for these larger numbers, following my first parenthesized term with a comma and then using a second parenthesized term with {3}, but then it would not work for those only in the hundreds.



Is there a way, using wildcards, to find both in a single search?
Reply With Quote
  #2  
Old 10-17-2018, 01:38 PM
Guessed's Avatar
Guessed Guessed is offline Adding a symbol to numbers in a table Windows 10 Adding a symbol to numbers in a table Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Find
<([0-9,]{1,}).([0-9]{2})

Replace
$\1.\2
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 10-22-2018, 08:05 AM
Ulodesk Ulodesk is offline Adding a symbol to numbers in a table Windows 7 64bit Adding a symbol to numbers in a table Office 2013
Word 2013 Expert Cert
Adding a symbol to numbers in a table
 
Join Date: Sep 2009
Location: Virginia
Posts: 872
Ulodesk is on a distinguished road
Default

Thank you, sir!
Reply With Quote
Reply

Tags
numbers, tables, wild cards



Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding a symbol to numbers in a table Footer for page numbers recently started showing a colored field when adding page numbers thefonebug Word 12 10-24-2016 05:18 AM
Adding a symbol to numbers in a table Make my own image and save as symbol in the symbol chart DeniseN Office 1 03-20-2015 01:13 AM
Adding a symbol to numbers in a table Adding station numbers mbenton Excel 10 01-27-2015 09:13 AM
Word table - how do I append % symbol to each value in columns 3 & 4 of a table Dawsie Word 4 03-06-2013 12:33 AM
Adding a symbol to numbers in a table adding numbers in same cell jetdude68 Word Tables 1 07-20-2010 12:30 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:02 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