| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Data Validation (Specific Decimals or Whole #)
is it possible to set up a data validation where the only numbers that someone can enter into a cell are either whole numbers or end in ".5" numbers can be 0, 1, 1.5, 5000.5, etc.... basically any decimals other than .5 or .0 are not wanted. can anyone help out? -- testes ------------------------------------------------------------------------ testes's Profile: http://www.excelforum.com/member.php...o&userid=24965 View this thread: http://www.excelforum.com/showthread...hreadid=384925 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| data validation lists | Excel Discussion (Misc queries) | |||
| Error Message with Data Validation | Excel Discussion (Misc queries) | |||
| #VALUE# error with Data Validation | Excel Discussion (Misc queries) | |||
| Pivot table - printing specific data | Excel Discussion (Misc queries) | |||
| Data Validation | Excel Discussion (Misc queries) | |||
Threaded Mode
