Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have the following Data Validation in a cell using the "Custom" validation
=J10<"" This only allows input if there is a value in J10. How would I also include within this validation a requirement for the user to enter only values (which may include decimal places)? The problem I am encountering at the moment is that some users are hitting the space bar to change/remove figures and this is causing problems within a separate export sheet I have, as it interprets the values entered as "Space" although visually it looks blank Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
How can I combine data from a list? | Excel Discussion (Misc queries) | |||
How do I combine tabulated data into a single column and list alphabetically? | Excel Discussion (Misc queries) | |||
Combine Data from 2 worksheets | Excel Discussion (Misc queries) | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |