Date values are converted to formulas
 

I am using a workbook created by an associate in which 1 of the worksheets
will not allow a date to be entered other than as a text string. "Normal"
entry in a "03/10/306" style is converted into its mathematical formula
equivalent and a numercal answer. What can I do to fix this ...beyond copy
and paste to another worksheet.

Help please!

Date values are converted to formulas
 

Look at ToolsOptionsTransition tab and uncheck any transition options

--
Kind regards,

Niek Otten

"Al B" wrote in message ...
I am using a workbook created by an associate in which 1 of the worksheets
will not allow a date to be entered other than as a text string. "Normal"
entry in a "03/10/306" style is converted into its mathematical formula
equivalent and a numercal answer. What can I do to fix this ...beyond copy
and paste to another worksheet.

Help please!