Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom data validation
How can I ensure that inputs in a particular cell are in one of the
following formats: # / # # / ## ## / ## ## / ### ### / ### Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom data validation
First, I assuming that you really don't mean format, because if you do you
can set the format of the cell using Format, Cells before the data is entered. If instead you want to make sure that the user enters a 2 digit number divided by a 2 or 3 digit number, etc. Then you will want to use a Worksheet_Change event and write code to test the entry. Do you want a code solution? And if so have you specified all the legal entries, for example, #/### is not legal, nor is ###/####? -- Thanks, Shane Devenshire "Matt" wrote: How can I ensure that inputs in a particular cell are in one of the following formats: # / # # / ## ## / ## ## / ### ### / ### Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom data validation | Excel Discussion (Misc queries) | |||
Data Validation - Scroll in the formula bar for a custom criteria | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Custom Format and Data Validation Q | Excel Worksheet Functions | |||
Excel2000: Custom data validation and named ranges | Excel Discussion (Misc queries) |