In Excel 2003 it was possible to specify the range of a date axis simply by
entering the minmum and maximum as dates (e.g. "1 jan 2008").

In 2007 the "format axis"- "axis options" dialog simply ignores minimum
and maximum values entered as date. You have to convert the date to a number
manually (i.e. 39448) before specifying minimum and maximum values.

Is there any other way to do it in 2007 ?

And why was the very handy 2003 behaviour removed in 2007 ?

Morten