You could put a conditional format on it and if the result is zero, format it
with the white font.

--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"Helpme" wrote:

I am transferring information from a raw form to an order form and when i go
to the order form i get a 0 and in the formula bar it says =RAW!F1. how can
i get rid of this 0 permanetly.