| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
excel validation to 1 decimal place
I want to restricted cell input to 1 delimal place ie 77.9.
if user tries to input 77.09 or 77.48 or any figure to two decimal place they are prevent and must put in ie 77 or 77.4. Any ideas |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Automate Excel to powerpoint - Graphs along with Datasheet (not workbook) | Charts and Charting in Excel | |||
| How do I convert decimal inches to fractions in excel | Excel Discussion (Misc queries) | |||
| How Do I open an excel file without Excel Viewer support | Excel Discussion (Misc queries) | |||
| EXCEL Decimal changes during WORD Merge | Excel Discussion (Misc queries) | |||
Threaded Mode
