But that only works on text (or numbers treated as text).


Nick Hodge wrote:

Martin

I couldn't understand the original post unfortunately, but you can change a
single character in excel. Just highlight it in the formula bar, format how
you want, bold, underline,colour, etc and voila!

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS

"Martin P" wrote in message
...
It seems to me that you cannot change the colour of a single digit in
Excel.
If you change one, then you change them all. A suggestion is to copy the
cells to Word and use Edit, Replace. In Find What type 3. In Replace With
do
not type anything but choose something under Format (for example Font
Color
or Highlight or both). Do not enable Wildcards.

"Phyllis" wrote:

Suggestion for Microsoft

I would like to be able to format a single digit in a number cell that
contains 2 or more digits. For example, if I type 346 in a cell, I would
like
to be able to bold or color just one of the digits, say the 3. The
reason:
to help me test a theory. If the solution to a problem could be either a
3,
4, or 6 in a given cell, I migth want to test the theory that it's the 3.
If
I could color the 3 in the cell containing 346, and then color the
resulting
answer in other cells, I could track all the changes I made to test the
theory without erasing the other possible variables incase my theory is
wrong. Yes, I confess, it's to help me solve a five-star (highest
difficulty) Sudoku puzzle.

Other suggestions for testing a theory without eliminating the variables
are
welcome. Programming an IF logic sequence would be too complex. (I've
tried
just bracketing the theoretical numbers, but it gets clumsy, confusing
and
cumbersome.)
--
PT




--
PT

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the
"I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

--

Dave Peterson