Hello,

How do I get rid of this error message from my cell -#Value!.  I have a cell
C1 which has a number for example 500 and C2 I have XXX in the cell and C3 I
used this formula =C1-C2, but I get the #Value! error message.  What is
funny about this is on one worksheet cell C3 returns the number 500, but on
another worksheet I get the error message.  Why? and how do get the value?
Any tips will be appreciated.  Thank you in advance.

Cheers