Excel formatting question

You could do it but reckon you'd need to use some VBA to do your formatting, you can display text in multiple colours but not formulas or numbers as far as I know.

Guess a lot depends what you're trying to do on the best way to acheive it, you could display the third decimal place in a different cell and format that or maybe look at conditional formatting if there are certain numbers you want to stand out.

Not trivially.  What are you trying to achieve?  It's a bit simpler if you're just using this for display purposes rather than using it in later calculations (you can always have another cell, hidden if necessary, holding the raw number for computation purposes).

Thanks for the replies.

To be honest, I only want to achieve the above for cosmetic reasons. I have a row of numbers that I only really need to two decimal places but it is handy (but not essential) for me to know the third place. I am used to reading the numbers formatted as two places and find it distracting when formatted to three so I thought there might be a simple solution. Obviously, there is not so I will leave it.

Simple solution is to add a column to the right of the one your numbers are in with the formula that it equals your column or whatever and then format one column to be 0.00 and one to be 0.000

If it's just for display purposes why not just set a macro button to toggle between the column being formatted to 2 and 3 places.

Alternatively, it's easy enough to isolate the third decimal with a formua like

=MID(ROUND(A1,3),FIND(".",ROUND(A1,3))+3,1) (assuming your number is in A1)

You could easily set up a macro button to toggle between the column with the formulas   being displayed or not displayed.