Thank you. I'm using Excel 2003.

Your formula works great.

Thanks again.

Bob Z

"T. Valko" wrote:

My limits are any value =15.0 to <=100.0
as long the is only 1 decimal point.

What version of Excel are you using?

Let's assume cell A1 is the cell of interest.

In Excel 2007...

Select cell A1
Data tabData toolsData Validation
Allow: Custom
Formula:

=AND(A1=15,A1<=100,MOD(10*A1,1)=0)

OK out

In Excel 2003 and earlier...

Select cell A1
Goto the menu DataValidation
Allow: Custom
Formula:

=AND(A1=15,A1<=100,MOD(10*A1,1)=0)

OK out


--
Biff
Microsoft Excel MVP


"Bob Zimmerman" wrote in message
...
I would like to know how to limit a cell to only allow entry of the
following
number values of 1 decimal point.
My limits are any value =15.0 to <=100.0 as long the is only 1 decimal
point.

I'd appreciate any input.

Bob Z


.