not showing 0 in a cell or replacing it with a blank cell

[Zealotwraith]

Good day,

I use a vlookup formula to bring some values,

for those that are 0, I'd rather leave the cell empty,

Is there a way to set 0 as a blank cell? (reason for this is that conditional formatting changes the color if it nonnatives a 0)

if not,

I wanted to try and replace all the 0's for a blank cell or for a space,

however replacing them changes numbers such as 102 to 1_2 (underscore represent the space),

thanks for the help!

[wfm007]

Set your vlookup as if(vlookup = 0,"",vlookup)

[Zealotwraith]

found the answer on Microsoft's web page

http://office.microsoft.com/en-us/ex...010070461.aspx