Results 1 to 17 of 17

Data validation bug?

Threaded View

swaugh Data validation bug? 11-30-2010, 06:55 PM
JBeaucaire Re: Data validation bug? 11-30-2010, 07:31 PM
swaugh Re: Data validation bug? -... 12-01-2010, 03:59 PM
NBVC Re: Data validation bug? 12-01-2010, 05:31 PM
swaugh Re: Data validation bug? 12-01-2010, 06:32 PM
Cutter Re: Data validation bug? 12-01-2010, 08:12 PM
NBVC Re: Data validation bug? 12-01-2010, 09:34 PM
romperstomper Re: Data validation bug? 12-02-2010, 06:03 AM
NBVC Re: Data validation bug? 12-02-2010, 08:41 AM
romperstomper Re: Data validation bug? 12-02-2010, 08:50 AM
NBVC Re: Data validation bug? 12-02-2010, 08:59 AM
swaugh Re: Data validation bug? 12-03-2010, 03:30 PM
Kraglin1 Re: Data validation bug? 04-05-2013, 09:56 AM
JBeaucaire Re: Data validation bug? 04-05-2013, 12:07 PM
ArviL Re: Data validation bug? 04-15-2013, 09:00 AM
leo black Re: Data validation bug? 06-28-2013, 02:16 AM
arlu1201 Re: Data validation bug? 06-28-2013, 02:41 AM
  1. #1
    Registered User
    Join Date
    11-30-2010
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2007
    Posts
    4

    Data validation bug?

    I have a simple data validation formula to check whether a valid number is entered or not. It works, provided that the user types the number, then presses either the ENTER or TAB key.

    If they type a number, then click another cell using the mouse, the number will be accepted, with apparently no data validation check kicking in. In other words, it will accept an invalid number.

    I have style STOP selected, I have IGNORE BLANK clicked on (though I don't think that even applies here).

    Am I missing something really obvious here?
    Last edited by swaugh; 12-03-2010 at 03:32 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1