Format Cells

  • Thread starter Thread starter Andy
  • Start date Start date
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
 
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
 
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
 
Back
Top