Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-23-2015, 04:58 AM
rsrasc rsrasc is offline Macro Needed to Replace a Period by a Comma Windows 7 64bit Macro Needed to Replace a Period by a Comma Office 2010 64bit
Competent Performer
Macro Needed to Replace a Period by a Comma
 
Join Date: Mar 2014
Location: Germany
Posts: 148
rsrasc is on a distinguished road
Default Macro Needed to Replace a Period by a Comma

Hi all,

I'm looking for a macro to replace the period only for numbers with a comma in a document.



For example, $5.25 to $5,25

Thanks!
Reply With Quote
  #2  
Old 08-23-2015, 05:16 AM
Charles Kenyon Charles Kenyon is offline Macro Needed to Replace a Period by a Comma Windows 8 Macro Needed to Replace a Period by a Comma Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,140
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Why do you need a macro?
Replace using wildcards
Reply With Quote
  #3  
Old 08-23-2015, 03:23 PM
macropod's Avatar
macropod macropod is offline Macro Needed to Replace a Period by a Comma Windows 7 64bit Macro Needed to Replace a Period by a Comma Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Not only do you not need a macro, I've previously pointed you to links on how to use wildcards and I've given you macros that use them...
See, for example:
https://www.msofficeforums.com/word-...lace-text.html
https://www.msofficeforums.com/word-...highlight.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Advanced Find & Replace help needed ballst Word 8 12-11-2014 07:50 AM
Macro Needed to Replace a Period by a Comma New Find/Replace Wildcard Needed rsrasc Word VBA 2 11-11-2014 09:46 AM
Macro Needed to Replace a Period by a Comma Find/Replace Wildcard Needed rsrasc Word VBA 4 11-11-2014 08:28 AM
Count the common time period (month) between two date period of time Barni Excel 6 08-15-2014 07:52 AM
Macro Needed to bold specific lines and Macro to turn into CSV anewteacher Word VBA 1 05-28-2014 03:59 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:28 PM.


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