Keep text out of numeric field
I am trying to "idiot proof" a worksheet. I know how to protect and
unprotect cells and worksheets... What I am trying to do now is to make it so that someone cannot enter text in a numeric field. I have not figured out how to do that yet. I would think it would be rather common, but I don't see how it is done. Thanks in advance. Diane |
Keep text out of numeric field
Select the cells you want to use for numbers.
Click on Data Validation. Change the block that says Allow Any value to Allow Whole Numbers or Decimals, depending on what you want, set the criteria to greater than and make it 0 or 0.01. You can only enter those values then, and not any text. Rather, you can type text into such a cell, but when you press <Enter, an error message pops up, stating that you cannot insert text. -- HTH Kassie Replace xxx with hotmail "Diane" wrote: I am trying to "idiot proof" a worksheet. I know how to protect and unprotect cells and worksheets... What I am trying to do now is to make it so that someone cannot enter text in a numeric field. I have not figured out how to do that yet. I would think it would be rather common, but I don't see how it is done. Thanks in advance. Diane |
All times are GMT +1. The time now is 03:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com