There's an option under the Office button|Excel Options button.

Look for one of the Lotus transition settings.

In xl2003, it's called: Transition Formula Entry

(Uncheck it)

Clark wrote:

Microsoft Excel 2007

I have a column whose fields are defined as 'date'. When I type the date
into the field it will not display the correct date. Example:

I type in '9/29/08' and the field displays '1-Jan-00' instead of
'29-Sep-08'. In the formula bar it reads what i typed...'=9/29/08'

Any suggestions as to why this is happening??

--

Dave Peterson