How can I allow only asterisk (*) as cell input (asterisk as a character not as a wildcard)?
I tried using Custom as a Validation criteria but not sure what I should put as formula.
How can I allow only asterisk (*) as cell input (asterisk as a character not as a wildcard)?
I tried using Custom as a Validation criteria but not sure what I should put as formula.
Perhaps try =~*
Using either "~*" or ~* in the formula field gives the "the value doesn't match the data criteria" error when I enter *.
Last edited by DavidE21; 01-12-2019 at 12:12 PM.
A bit long winded, but try this...
=MATCH("~*",M4,0)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Please try Custom Data validation at A1
=A1="*"
change A1 to another cell if needed.
Another option would be to use list, rather than custom & enter * as the source.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks