Turn off Excel changing all date like strings to dates

[Chrisso]

I have a cell that I want my users to enter date of manufacture.
Examples are:
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

 

[Chrisso]

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

 

[Dave Miller]

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

 

[Guest]

hi.
preformat the column as text or have users enter an apostrophe (') before
the data.

Regards
FSt1