Hi
I'm looking for a way I can restrict the content of a cell to: Any number OR "X".
I tryed using data validation but I couldn't find a way to use custom validation and enter these validations.
Is there a way to do what I want to do? Please help me!!
Benedict
Last edited by benedictexcel; 02-07-2012 at 03:03 PM.
Maybe =or(isnumber(a1), a1="x")
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
Great thanks!! i'll remember that!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks