LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
Cutter
 
Posts: n/a
Default Removing an inch mark


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert decimal to inch & fraction davepatrob Excel Discussion (Misc queries) 1 December 31st 05 05:05 AM
How do I insert a dot/check mark in a cell in Excel? sue New Users to Excel 3 October 27th 05 07:08 PM
How do I find and replace a question mark in Excel? Ranpalandil Excel Discussion (Misc queries) 1 September 7th 05 10:20 PM
Can tick mark labels be flipped about axis? [email protected] Charts and Charting in Excel 1 July 20th 05 05:03 PM
HOW DO I USE WATER MARK " DRAFT" IN EXEL john p max New Users to Excel 3 May 5th 05 02:21 AM


All times are GMT +1. The time now is 04:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"