I'm attempting to require a numerical entry in a cell using data validation. The function =AND(ISNUMBER(cell),NOT(ISBLANK(cell))) does not perform as intended. Unchecking "Ignore Blank" has no effect. The ISNUMBER function evaluates to TRUE on a blank cell. When used outside of data validation, NOT(ISBLANK(cell)) evaluates to FALSE on a blank cell, making me think the AND(...) function should be sufficient.
Valid entries are any number, including 0.
Can this be done without VB?
George
Last edited by geoB; 03-29-2009 at 06:17 PM.
Data validation includes Whole number and Decimal options.
You can use conditional formatting to change blank cells to annoying red.
Entia non sunt multiplicanda sine necessitate
True, but they also require minimum and maximum values. My requirement is simply any numerical value. I guess I could specify Excel's max and min cell values, whatever they are.
g
+/-9.9E+307 is not overly restrictive ...
My students wouldn't know how to cube a googol, so I'll go with it.
Thanks.
g
Spoke too soon. Decimal -9.9E+307<cell<+9.9E+307 still allows blank?????
g
That's what I suggested the conditional formatting for.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks