Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Custom data validation formula for cell A1:
=OR(A1="N.A.",ISNUMBER(A1))
Data Validation: specified text or any number allowed in the same cell?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
Hi! I would like to control the data entered into Excel cells. I would like to allow the following entries: either text "N.A." or any number (but not a combination of a number and text.) In other words the cell would contain either "N.A." or "30,6" but not "30,6 pg/mL". Can somebody please help me? Thanx a lot in advance!
Microsoft 365 and Office | Excel | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Anonymous
1 additional answer
Sort by: Most helpful
-
Anonymous
2010-09-02T07:57:09+00:00 Luke, thank you so much - it worked! :)