| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Limiting Validation entries to 2 places after a decimal
I have a multi-user spreadsheet to enter dollar values. How can I limit a
user from entering, for example, 43.703 when the correct entry is 43.70? I can do this by changing the number format but do not want to do that. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel adds phantom decimal places: why? | Excel Discussion (Misc queries) | |||
| Max decimal places | Excel Discussion (Misc queries) | |||
| FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
| decimal places within a formula | Excel Discussion (Misc queries) | |||
| Changing default decimal places | Excel Discussion (Misc queries) | |||
Threaded Mode
