Thanks "KL"

I'm sorry I must be missing something.

I have tried entering your suggestion in both conditional formatting and
directly in a cell using "My Formula" and neither seem to work (most likely
me at fault).

Can you help further please?

Regards

Mick


"KL" <lapink2000(at)hotmail.com (former ) wrote in
message ...
try this:

=IF(ISNA(yourFormula),"",yourFormula)

KL


"Mick" wrote in message
...
Can anyone help please with how to hide #N/A please?

I have tried conditional formatting but cant get the settings right.
--
Kind Regards

Mick


---
Outgoing mail is certified Virus Free by AVG.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.802 / Virus Database: 545 - Release Date: 26/11/2004





---
Outgoing mail is certified Virus Free by AVG.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.802 / Virus Database: 545 - Release Date: 26/11/2004