On some of my spreadsheets that use a bunch of formulas i use conditional
formatting to hide the zeroes:

Format Conditional Format:

Cell Value is: Equal to: 0

and my text color is white.

The cell value will remain 0, but for display purposes it'll show up blank.

Now if you're looking for a code to replace a returned value of 0 for
another value, then that's a different story.



"Newfie809" wrote:

I have a spread sheet with about 300 formulas and the formula is looking up
information and returning the answer from another workbook, but some of the
cells that do not have any information the fromula returns a "0" is there a
macro or a formula that if there is no information in that cell it is
returned blank?

thank you for you help
--
Newfie