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

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

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

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