That's so true. I'm also having trouble with this DV. It's so.... easily
bypassed.
First I thought that it's my formula problem but then I do the googling and
testing.
I finally found out that it's DV bug. Is there any possible way to make this
DV really working besides wait for microsoft to patch it?

"Ken Wright" wrote:

You've already been given the answer of DV, BUT, be aware that DV is easily
bypassed, and the user could simply copy a cell with a negative number and
paste it straight over that cell which will effectively remove the DV.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------
It's easier to beg forgiveness than ask permission :-)



"Skjetve" wrote:

How do you lock a cell, so the user can only write positive numbers in it?