![]() |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#3
|
|||
|
|||
|
Consider doing a find-and-replace operation where you replace "0" with "0", but the second one is formatted the way you want. In the replace window, click "More", and it'll give you formatting options. Then do the same for 1, 2, etc. - 10 find-and-replace operations is a bit clunky, but I can't think of a faster approach that is guaranteed to only pick up digits.
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need Help Deleting Numbers in Hour Format and Numbers in Sequence | rsrasc | Word VBA | 1 | 10-12-2016 02:49 PM |
Font Color automatically reverting back to Automatic
|
DuncanPaulD | Project | 3 | 09-11-2014 07:11 AM |
| Changing bar color automatically | Mahmuz | PowerPoint | 0 | 03-28-2012 11:49 PM |
| how to automatically add +1 to numbers in Contacts? | 34woody | Outlook | 1 | 08-25-2011 10:27 AM |
How to add the plus sign (+) automatically for the numbers which are positive?
|
Jamal NUMAN | Excel | 2 | 05-01-2011 03:15 PM |