saadferoze
New Member
I have applied data validation on the input cells to accept only the numbers by applying =isnumber(Cell number) which is working quite fine. but the problem which i am facing currently is when i try to put any thing other than number then it gives error that it can not accept it but when i revoke it ,my output cells show #Value. How can i rectify this and let it run smoothly .
Urgent response will be appreciated.
Regards
Saad
Urgent response will be appreciated.
Regards
Saad