ExcelBanter - Locking cells for numeric entries only

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Locking cells for numeric entries only (https://www.excelbanter.com/excel-discussion-misc-queries/107146-locking-cells-numeric-entries-only.html)

matt ball

Locking cells for numeric entries only

Can cells in MS Excel be locked so that only numeric entries will be
permitted? Perhaps alpha entries will be omitted or come back with an
error... is this possible?

Thanks for any help.

Matt

paul

Locking cells for numeric entries only

take a look at data validation
--
paul

remove nospam for email addy!

"matt ball" wrote:

Can cells in MS Excel be locked so that only numeric entries will be
permitted? Perhaps alpha entries will be omitted or come back with an
error... is this possible?

Thanks for any help.

Matt

matt ball

Locking cells for numeric entries only

Perfect! Thanks, Paul.

Matt

"paul" wrote:

take a look at data validation
--
paul

remove nospam for email addy!

"matt ball" wrote:

Can cells in MS Excel be locked so that only numeric entries will be
permitted? Perhaps alpha entries will be omitted or come back with an
error... is this possible?

Thanks for any help.

Matt

All times are GMT +1. The time now is 03:43 AM.