Custom format cells - how to make it say < number

L

liniis

Hi, I have a tiny question for you...

You know that one can get for example the format "percent" in a cell so
if I write 8, 8% will turn up in the cell. I would like to do the same
but with < so if I write 0,1 the cell will say <0.1. The only number in
the cell have to be 0.1 so I can use these numbers to make diagrams and
calculate etc. I have looked at the custom category on Format Cells
under Format but I can't come up with a format code that gives the
wanted result. So please, can anyone give me help on this....

Thanks!
/liniis
 
B

Bob Phillips

Is this what you mean

[<0]<0.0;General

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
L

liniis

....do you mean that I should write this in the custom category in the
"number" tab under "format cells"? I have tried that but excel returns
a warning sayin that Excel cannot use the number format I typed.
LMK...
/Liniis
 
B

Bob Phillips

I mean in the Custom selection of Format>Cells

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Top