I am attempting to enter a date to set the Min and/or Max value in the Axis
Options in a Line Chart. This is for the Vertical Axis.
When I enter a date ex 1/18/10 or 1/18/2010 in the Axis Options in a Line
Chart on the vertical axis, the value reverts to the original date code
40181.0 which is 1/3/10.
I used to be able to enter a date here and it would convert it. How Can I
get this to do it. Am I entering the information wrong.
My older version of excel (2002) I could even enter just the month and day
if I wanted the current year. ex 1/18 would have been sufficient and the
information was converted to the date number.

Does anyone know of a for sure fix yet??? SP2 did NOT fix this!
Thanks for any assistance!
Mark