Format Cells

[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

 

[IC]

I'm not sure you can do it within the cell, but in an adjacent cell try this

=IF(A1=0,"nil",INT(A1)&"Kg "&(A1-INT(A1))&"g")

assuming A1 holds your raw data.

Ian

 

[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