LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Limit data entry to 1/4" increments

I have a need to create a input sheet that only lets the user input
numbers in 1/4" increments like
33.00
33.25
33.50
33.75
50.25
22.75

NO 33.125 or 43.375 numbers.
Is there some way with data validation or other way? I tried cell
formating but it only displays it as a fraction. I want it to reject a
entry that does not equal a number on the quarter inch increment.

Thanks
Scott
 
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
Formula to confirm entry in Col "C" is valid for data in Col "A" VAPCMD Excel Discussion (Misc queries) 2 January 2nd 09 07:58 PM
copy data from one sheet to another "entry has to be same shape" des-sa[_2_] Excel Discussion (Misc queries) 3 July 26th 08 06:38 PM
How can you limit the data entry range in Excel? Joe Excel Worksheet Functions 2 December 26th 07 07:23 PM
"Abnormal behaviour" data entry form JR Hester Excel Discussion (Misc queries) 5 January 4th 07 11:04 PM
Data entry "+" results in "294" in XLS jaak de vuyst Excel Discussion (Misc queries) 1 October 22nd 06 06:18 PM


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

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

About Us

"It's about Microsoft Excel"