![]() |
#3
|
||||
|
||||
![]()
You can do all of this via wildcard Find/Replace, without the need for a macro. For example:
Find = [0-9]{1,} Replace = ^& will find & replace all number sequences. All you need do is specify the replacement font colour. For the separators, you could use: Find = [0-9][,.'][0-9] Replace = ^& Of course, you could also use the macro recorder to record these as a macro.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
numeric values |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Convert alphabets to numeric values | kjxavier | Word | 3 | 07-06-2014 05:34 AM |
Convert numeric values with decimals to alphabets | kjxavier | Word | 1 | 07-06-2014 01:44 AM |
![]() |
slovenc0417 | Excel | 2 | 06-07-2013 07:58 PM |
![]() |
achuki | Excel | 5 | 02-07-2012 02:14 PM |
![]() |
stnicholas81 | Excel | 1 | 07-25-2011 01:31 AM |