| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
restricting data entry to non-times
I actually need to have entries in some cells to be numbers or text
but NOT times. Thus I need the cells formatted as General. General formatting makes 10:00 show up as 0.416667. I need data entries to be restricted to non- times. Can I have data validation set up to restrict time entries only but still be able to enter numbers that can be used in formulas? I have tried =Right(A1,3)=":" in the custom setting under data validation but that doesn't seem to workThanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Restricting data entry to unique entries only in a specific range | Excel Discussion (Misc queries) | |||
| Restricting data entry to A-Z a-z 0-9 | Excel Discussion (Misc queries) | |||
| Restricting entry in B1 on the basis of entry in A1 | Excel Worksheet Functions | |||
| Restricting data entry | Excel Programming | |||
| Help With Restricting Values in Data Entry Forms please | Excel Programming | |||
Threaded Mode
