#,##0.#####

although this shows 21 as 21.

--
__________________________________
HTH

Bob

"driller" wrote in message
...
Hi again,

After long time w/o practice, please help me to use format in a column of
data

i.e. formatcellnumber....

21
21.1
21.15
21.154
21.1546

I need to show all the decimals w/o showing the tailing "0's"

if possible with a combined conditional color effect if the cell contain
number decimal numbers exceeds to 2 places. (i.e. 21.154, 21.1546, etc)

anything possible is appreciated in advance.
--
regards,