hi experts
I use normal way bye cell format by choose the cells and customize to make any value = 0 should convert to "-" and when make the cells contain numbers. it should show the numberformat #,#00.0 so far is ok , but if I use customize to make any value = 0 should convert to "-" .it will clear number format then the cells it will be like this ##### without any numberfromat . the question is. is there any macro or way to make value = 0 convert to "-" show the numberformat #,#00.0 at the same time without return the normal value .for instance I have columns B,F,H,M,N contains some numbers and zero .
I appreciate if anybody solve this dilemma
thanks in advance
I use normal way bye cell format by choose the cells and customize to make any value = 0 should convert to "-" and when make the cells contain numbers. it should show the numberformat #,#00.0 so far is ok , but if I use customize to make any value = 0 should convert to "-" .it will clear number format then the cells it will be like this ##### without any numberfromat . the question is. is there any macro or way to make value = 0 convert to "-" show the numberformat #,#00.0 at the same time without return the normal value .for instance I have columns B,F,H,M,N contains some numbers and zero .
I appreciate if anybody solve this dilemma
thanks in advance