| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fixed decimal places in Excel
I am designing an Excel spreadsheet as a template for data entry. I would
like the cell to only allow two decimal places to be entered. For example, if a person entered 1.234, I would like the value to be rejected. For my purposes, this would not be best accomplished through the fixed decimal option as the user can still enter this value and have it accepted. I have Excel 2003. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Set fixed Decimal places with no rounding | Excel Worksheet Functions | |||
| Data validation with a fixed amount of decimal places | Excel Worksheet Functions | |||
| Want Fixed Decimal places in only 1 column | Excel Discussion (Misc queries) | |||
| tools|options|Edit tab|fixed decimal places | Excel Discussion (Misc queries) | |||
| FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
Threaded Mode
