Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() How about Data Validation Select the cell that is used for the thickness input Go to Data Validation On the Settings tab under "Allow" choose decimal Set your Maximum and Minimum values which would cover acceptable entries Then click the Input Message tab and type a message which will show up when the user selects that cell - something like "Thickness Required - Type numeric characters only" Then on the Warning tab type in another message which will show up if your user fails to follow the first message - something like "Invalid Entry - Do not type non-numeric characters" Then click OK -- Cutter ------------------------------------------------------------------------ Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=539976 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
convert decimal to inch & fraction | Excel Discussion (Misc queries) | |||
How do I insert a dot/check mark in a cell in Excel? | New Users to Excel | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
Can tick mark labels be flipped about axis? | Charts and Charting in Excel | |||
HOW DO I USE WATER MARK " DRAFT" IN EXEL | New Users to Excel |