Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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 superuser.com/questions/279442/… –  Jeremy W Jun 15 '12 at 5:30
1  
It's close, but I don't think it's a duplicate. –  CharlieRB Jun 15 '12 at 14:17
add comment

1 Answer 1

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.