Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
DATA VALIDATION
xp/2003
I am trying to specify that fields in a column can only accept an entry between 03 and 83 and that each entry have two and only two numbers (03-83, in other words). The entries can be either number or text format. I can't find the combination of cell format and data validation that allows this. Ideas? -- William |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
DATA VALIDATION
Hi
Data Validation Allow: "Whole number" Data: "Between" Minimum: 3 Maximum: 83 Ok Format Number Custom Type : ##00 Ok Apply theese to the cells desired. Regards, Per "William" skrev i meddelelsen ... xp/2003 I am trying to specify that fields in a column can only accept an entry between 03 and 83 and that each entry have two and only two numbers (03-83, in other words). The entries can be either number or text format. I can't find the combination of cell format and data validation that allows this. Ideas? -- William |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
DATA VALIDATION
Format the cell, custom number format as 00 (I am assuming you always want
the preceding 0 to be shown for 03-09. Data|Validation Allow: Whole Number Data: Between Minimum: 3 Maximum: 83 Hope this helps. -- John C "William" wrote: xp/2003 I am trying to specify that fields in a column can only accept an entry between 03 and 83 and that each entry have two and only two numbers (03-83, in other words). The entries can be either number or text format. I can't find the combination of cell format and data validation that allows this. Ideas? -- William |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
DATA VALIDATION
Perfect! Thx.
-- William "John C" wrote: Format the cell, custom number format as 00 (I am assuming you always want the preceding 0 to be shown for 03-09. Data|Validation Allow: Whole Number Data: Between Minimum: 3 Maximum: 83 Hope this helps. -- John C "William" wrote: xp/2003 I am trying to specify that fields in a column can only accept an entry between 03 and 83 and that each entry have two and only two numbers (03-83, in other words). The entries can be either number or text format. I can't find the combination of cell format and data validation that allows this. Ideas? -- William |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Data Validation Update Validation Selection | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |