cell validations

[phaninfy]

HI,

I have to validate a cell's content while entering the value into the cell. The cell should accept numbers,+,- only.
i am using
=ISNUMBER(SUMPRODUCT(SEARCH(MID(G2,ROW(INDIRECT("1:"&LEN(G2))),1),"0123456789-+" )))</SPAN>


but now i have to include a new validation where atleast one '-' is mandatory. can someone help me with this.

Thank u in advance

 

[Andrew Poulsom]

Does this work for you?

=ISNUMBER(SUMPRODUCT(SEARCH(MID(G2,ROW(INDIRECT("1:"&LEN(G2))),1),"0123456789-+" ))+SEARCH("-",G2))