Barb -

The original cell contents a "UT076 7.000 DUE12/15/31"

I then use the MID Function in another cell to extract the sub-string:
"12/15/31"

In yet another cell, I add "0" to convert the text string to EXCEL Date
Format.

The resulting Excel Date is 12/15/1931 instead of the desired 12/15/2031.

I have followed the instructions in EXCEL Online Help labelled: "How Excel
interprets two-digit years" and have changed my settings so that yy=30 to 39
should be interpreted as 2030 to 2039.

This does correct NUMERIC entry errors, but it did not help the senario above.

Chris

"Barb Reinhardt" wrote:

What else is around it? It's hard to know what to tell you to do without
more details.

"CPodd" wrote:

The date is imbedded in the middle of a text cell in "mm/dd/yy" format.

"Barb Reinhardt" wrote:

It would help to know how they are entered.

"CPodd" wrote:

How can I change the way that excel inteprets "dates entered as text values"?
Maturity dates on 30-years bonds are incorrectly interpreted, even after I
change the Regional Options on the Control Panel.