Lock cell for number input

[msnews.microsoft.com]

Hi,

I am creating Excel file for users to fill in the data and send it back to
me. I have cells that require users to put in numeric value. How can I do to
only allow numerice value when users typing in the cells? I need to do the
same for percentage as well. For the percentage, my idea is to set the
format of the cell to be "Percentage" and then limit the value to between 0
to 1.

Thank you very much,
B

 

[David Heaton]

Hi,

I am creating Excel file for users to fill in the data and send it back to
me. I have cells that require users to put in numeric value. How can I doto
only allow numerice value when users typing in the cells? I need to do the
same for percentage as well. For the percentage, my idea is to set the
format of the cell to be "Percentage" and then limit the value to between0
to 1.

Thank you very much,
B

Click on the Data menu, then Validation.
From here you have numerous choices on how to restrict data entry into
the cells.

HTH

Regards

David

 

[AltaEgo]

Data validation will ensure only number can be entered into cells.

Excel 2003
Select your cell range, click menu item 'Data', select 'Validation..."
Choose whether you want whole numbers or decimals from a drop-down list.

Probably best to forget the 'Input message' tab but enter and Error Alert so
users know how they offended by trying to enter something other than
numbers.

Excel 2007

http://office.microsoft.com/en-us/excel/HP100726001033.aspx?pid=CH100648501033

 

[Dave Peterson]

I'd start by looking at Data|Validation.

Debra Dalgleish has instructions here:
http://contextures.com/xlDataVal01.html