View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
liniis
 
Posts: n/a
Default Custom format cells - how to make it say < number


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


--
liniis
------------------------------------------------------------------------
liniis's Profile: http://www.excelforum.com/member.php...o&userid=31615
View this thread: http://www.excelforum.com/showthread...hreadid=513105