| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Turn off Excel changing all date like strings to dates
Silly me. I just had to set the target cells type to "Text" first.
Why do you find the solution to your prblem the moment you post it on the newsgroup!? Chrisso |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Turn off Excel changing all date like strings to dates
Either set the formatting for that column to text or have the user
enter a single apostrophe before the date, '03-01 Regards, David Miller |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Turn off Excel changing all date like strings to dates
hi.
preformat the column as text or have users enter an apostrophe (') before the data. Regards FSt1 "Chrisso" wrote: 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 |
| Reply |
| 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) | |||
Hybrid Mode
