I am finding in 2007 that if i go to the "format axis" dialog, and for "max"
put a date, like "5/1/07", this will not format the axis with that as the
maximum. I have to [correctly] translate it to the serial number for the
date (in this case 39203) and enter that value into the dialog. In previous
versions, one could just enter the date in this dialog and the chart axis
was correctly formatted with the date value that you entered directly into
the dialog as the correct max for the axis [with no need to translate to
serial number for that date].

Is this a bug? Or is this the intended behavior? If so, why? Its a real
hassle to go back to the sheet and figure out what the correct serial number
should be in order to enter it into the dialog. Is there an option or a way
around this [extremely irritating] behavior?

Thank you. tom