I want to use the Data Validation in Excel to prevent users from entering a non-decimal value, but I want to allow them to enter any decimal value, however you are forced to provide a range or restriction. Is there way to force a decimal, but not have to put a restrictions on the range of values?
Method 1: Checking for any number
where A1 is the cell you are validating. Do not include $ so you can copy/paste the validation to other cells.
Method 2: Checking for decimal pts
Create a blank column beside your data. For this example, you want users to enter values in column A, so we'll create a blank column in B.
In cell B1, enter this formula and drag it down.
Credits to DMA57361 for the tip
I'm sure there are other methods. This was all I could muster in a few mins.
|show 3 more comments|