How can i change value of number to zero, when i have

V

Vytautas

How can i change value of number to zero, when i have 00000.000 "" formula
rezult?
For example A1=00000.000 "E"
A2=00000.000 "E"
The SUM value of A1 and A2 is 00000.000 "", but I need that rezult would
display like 0 "" if there is no whole numbers in A1 and A2.
Thanks for helping :)
 
A

Adam Kroger

Have you tried using the format cell option.

r-click -> Format Cells -> Number tab -> select Number in the window and you
can specify the decimal places, and there are custom options as well.

I'm not a guru, but if it works, it is the simple solution.

Adam
 
V

Vytautas

Well, I have try, but the reason is that I need to format number in such way,
IF the value is above zero then it stays like it is (00000.000 "E1"), but if
countered numbers value is equal to zero then i need change format to 0 "E1".
And there is no, or i dont see the way i can do it in your sugestion. But
thanks anyway, ill keep trying to solve my problem :)
 
Top