You could use conditional formatting to hide them. They'll still be there,
you just won't be able to see them but if these results are used in other
calculations this could be a problem.

To use conditional formatting:

Select the range of cells in question. Assume this is A1:A10
Goto the menu FormatConditional Formatting
Formula Is: =ISNA(A1)
Set the font color to be the same as the fill color
OK out

Biff

"Turk" wrote in message
...
Thank you Max,

However my formulae will be a bit too long if using your method, any
alternate way to do it please?

Turk



"Max"
...
Use ISNA around your formula returning the N/As, eg:
=IF(ISNA(yourformula),"",yourformula)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Turk" wrote:
Dear all,

How to format a cell to make it blank if it's content is "N/A"

Thanks


Turk