Format Cells

A

Andy

Two questions for you all..

1) How do I format a cell if the value is over or equal to
0.001 as 00Kg 001g?

2) if the value of the cell is zero how do i write "nil"
in the text?

I have looked at format cells, but can not work out how to
do this.

Thanks

Andy
 
R

RagDyer

Try this "Custom Format":

00"Kg". 000"g.";[RED](00"Kg". 000"g.");"nil"
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Two questions for you all..

1) How do I format a cell if the value is over or equal to
0.001 as 00Kg 001g?

2) if the value of the cell is zero how do i write "nil"
in the text?

I have looked at format cells, but can not work out how to
do this.

Thanks

Andy
 
Top