Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a spreadsheet that 4 users can update. In several columns, they should only be inputting dates, but some input text. I would like to lock the format so that if text is entered, either it is not accepted or an error appears.

Is there a way to do this without macros?

share|improve this question
possible duplicate… – Jeremy W Jun 15 '12 at 5:30
It's close, but I don't think it's a duplicate. – CharlieRB Jun 15 '12 at 14:17

Using validation you can enter a custom Validation Criteria using a formula to prevent text input. In my example the dates are entered in cells A3 through A51. Adjust this to be the cells your dates are entered into.

enter image description here

On the Input Message tab remove the check from the box. On the Error Alert tab you can adjust the message as you see fit.

enter image description here

Click OK to save it. When text is entered into the cell you will get an error message.

enter image description here

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .