Limit Cell Content
in [Functions]
|
From: Bob Zimmerman on 13 May 2010 22:31 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
From: ozgrid.com on 13 May 2010 23:21 Data Validation http://www.ozgrid.com/Excel/data-validation.htm -- Regards Dave Hawley www.ozgrid.com "Bob Zimmerman" <BobZimmerman(a)discussions.microsoft.com> wrote in message news:BB18835A-8125-4DFB-99B9-06AAA65A3DBB(a)microsoft.com... >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
From: T. Valko on 13 May 2010 23:43 >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 tab>Data tools>Data 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 Data>Validation Allow: Custom Formula: =AND(A1>=15,A1<=100,MOD(10*A1,1)=0) OK out -- Biff Microsoft Excel MVP "Bob Zimmerman" <BobZimmerman(a)discussions.microsoft.com> wrote in message news:BB18835A-8125-4DFB-99B9-06AAA65A3DBB(a)microsoft.com... >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
From: Bob Zimmerman on 14 May 2010 12:48 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 tab>Data tools>Data 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 Data>Validation > Allow: Custom > Formula: > > =AND(A1>=15,A1<=100,MOD(10*A1,1)=0) > > OK out > > > -- > Biff > Microsoft Excel MVP > > > "Bob Zimmerman" <BobZimmerman(a)discussions.microsoft.com> wrote in message > news:BB18835A-8125-4DFB-99B9-06AAA65A3DBB(a)microsoft.com... > >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 > > > . >
From: T. Valko on 14 May 2010 13:43 You're welcome. Thanks for the feedback! -- Biff Microsoft Excel MVP "Bob Zimmerman" <BobZimmerman(a)discussions.microsoft.com> wrote in message news:714AE629-1EB8-4285-8B9D-08526C2BB075(a)microsoft.com... > 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 tab>Data tools>Data 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 Data>Validation >> Allow: Custom >> Formula: >> >> =AND(A1>=15,A1<=100,MOD(10*A1,1)=0) >> >> OK out >> >> >> -- >> Biff >> Microsoft Excel MVP >> >> >> "Bob Zimmerman" <BobZimmerman(a)discussions.microsoft.com> wrote in message >> news:BB18835A-8125-4DFB-99B9-06AAA65A3DBB(a)microsoft.com... >> >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 >> >> >> . >>
|
Pages: 1 Prev: How to have Sheet1 list Sheet2 rows matching text? Next: Countif gone wrong |