| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Limit Cell Content
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Limit Cell Content
Data Validation
http://www.ozgrid.com/Excel/data-validation.htm -- Regards Dave Hawley www.ozgrid.com "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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Limit Cell Content
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Limit Cell Content
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 . |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Limit Cell Content
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Bob Zimmerman" wrote in message ... 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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing the cell format doesn't change existing cell content | Excel Discussion (Misc queries) | |||
| copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) | |||
| Is there a way to limit the content of a cell to 5 choices? | Excel Worksheet Functions | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Linear Mode
