Spreadsheet 123 Excel 2007 FAQs: Allow only Numbers

Also learn how to set up a cell to only allow numbers in Excel 2003/XP/2000/97.

Question:  In Excel 2007, I want to set up a cell to only allow numbers. How can I do this?

Answer:  Select the cells that you wish to restrict to a certain number of characters. In this example, we've selected cells A2 to A6.

Select the Data tab in the toolbar at the top of the screen. Then in the Data Tools group, click on the Data Validation drop-down and select Data Validation.

When the Data Validation window appears, set up your criteria. In this example, we've setup the cells to allow a positive number.

Next, click on the Error Alert tab.

Enter an Error message to appear when data entered does not conform to the validation rules.

Now if a value is entered in one of those cells is not a positive number, the following error message will appear: