Archive of Mr Excel Message Board

Back to Data in Excel archive index
Back to archive home

cell protection?

Posted by linda childs on July 30, 2001 7:45 PM

I have a huge work sheet that is accessed and updated by numerous employees. I would like to prevent them from entering non-numeric numbers into certain fields. Is there a simple way to do this? I know it can be done using the dialog boxes, but that is too time consuming to redo all the data fields.

Thanks you!

Re: cell protection?(maybe data validation??)

Posted by steve w on July 30, 2001 7:54 PM

Try data validation
steve w

Re: cell protection?(maybe data validation??)

Posted by L.Childs on July 30, 2001 8:01 PM

I'd love to - but I don't know how.

Data validation to control the input

Posted by Aladin Akyurek on July 31, 2001 12:30 AM

Suppose A1 on worksheet X is one of the entry/input cells and is empty.

Activate A1.
Activate the option Data|Validation.
Select Custom for Allow on Settings tab of the Data Validation dialog.
Enter as Formula:

=ISNUMBER(A1)

If you so desire, you can include a message via Error Alert tab.

Copy down A1 as far as needed.

Note. If you have more conditions on the numbers to be entered, the above formula can be extended to cover them.

Aladin

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.