![]() |
|
|
|
#1
|
||||
|
||||
|
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 Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 |
Sorting Alphanumeric & Numeric values
|
slovenc0417 | Excel | 2 | 06-07-2013 07:58 PM |
Handle Text / Numeric values in SSRS while Export To Excel
|
achuki | Excel | 5 | 02-07-2012 02:14 PM |
[How To] Generate Alpha Numeric Values in Excel 2010
|
stnicholas81 | Excel | 1 | 07-25-2011 01:31 AM |