I hate putting posts in the Bugs category. I don’t know why I even made this category. Well, here it goes anyway – let me know if you’ve seen this before.
I had some data validation set up in a cell. The cell is supposed to end up being a web address and, of course, excel automatically converts it to a hyperlink. That seems to circumvent the data validation. Here’s the steps:
Set up Data Validation in a cell
Now enter some text in that cell that will be sure to be converted to a hyperlink and also that will fail the validation
Hit enter and you should get this message
Now click Retry, then press Esc and you’ll get invalid text in the cell
Seems like a bug to me. Another way to beat Data Validation, what a surprise.
BTW: Excel 2000, WinXP Pro