Lock cell for number input

  • Thread starter Thread starter msnews.microsoft.com
  • Start date Start date
M

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
 
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 to expand...


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
 
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
 
Back
Top