| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn off Excel changing all date like strings to dates
I have a cell that I want my users to enter date of manufacture.
Examples a 03-01 06/07 They must match one of these patterns: XX-XX XX/XX I want to keep these values as they were entered by the user. My problem is Excel wants to turn them into dates when they are entered by the user causing problems for my validation logic. Is there a way I can tell Excel to translate data entered in these cells as text and not to convert them to dates. I have tried changing the cell type on Worksheet_Change but Excel has already changed the data to a date. Chrisso |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why does numbers automaticly turn to dates in Excel? | New Users to Excel | |||
| Changing dates automatically with the computer date | Excel Discussion (Misc queries) | |||
| Changing dates to date format | Excel Discussion (Misc queries) | |||
| Changing text dates to date serial numbers | Excel Worksheet Functions | |||
| changing dates in a date formated column ? | Excel Discussion (Misc queries) | |||
Threaded Mode
