Is there any way to automatically format ALL numbers with a certain color?

[olegred]

I guess not, but I thought I will ask you, guys.



Thanks

[gmayor]

Automatically? No, but you could probably use the replace function with the wildcard option set to find numbers and format them with the required colour - see http://www.gmayor.com/replace_using_wildcards.htm

[Alsadius]

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.

[macropod]

Originally Posted by Alsadius

I can't think of a faster approach that is guaranteed to only pick up digits.

Perhaps you should have looked at the link Graham provided...

Moreover, you don't even need to use wildcards if all you're concerned about is digits! Simply use:
Find = ^#
Replace = ^&
with the replace formatting set appropriately. But then, numbers don't always consist of digits alone - thousand & decimal separators are quite common. And dates use digits, too, but aren't numbers...