Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
changinging the color of sign digit
There's no way to do this and keep the entry a number. You *could* use
an event macro to convert the number to text, then format the text, but the entry would no longer work in math operations. Post back if you want to pursue that option. In article , "hassan barjini" wrote: I would like to know how can I change the color of digit for example if I write the number -12.52 the color of the sign will change to blue and the rest will change to red. best barjini |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
changinging the color of sign digit
I would like to know how can I change the color of digit
for example if I write the number -12.52 the color of the sign will change to blue and the rest will change to red. best barjini |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert 2 digit month to 4 digit years and months | Excel Worksheet Functions | |||
Color a single digit in a mult-digit number cell | Excel Discussion (Misc queries) | |||
How do i put a addition sign before a digit in the cell box? | Excel Discussion (Misc queries) | |||
Tell users how to sort 5 digit and 9 digit zipcodes correctly aft. | New Users to Excel | |||
When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) |