I downloaded and installed Service Pack 2 but it didn't seem to make a
difference. Any other suggestions?


"Andy Pope" wrote:

Hi,

The ability to enter dates directly, although not time, is fixed in Service
pack 2.
http://office.microsoft.com/en-gb/do...s/default.aspx

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"jschultzbass" wrote in message
...
I have a scatter chart with dates on the x-axis and data on the y. When
trying to change the range of my x-axis, I right click on the x-axis,
click
"format axis" and for "Minimum" and "Maximum" I click "Fixed" but it will
only let me enter dates in the number format (i.e. 39983 instead of
6/19/2009). This is really annoying because I am constantly changing
ranges
to zoom in on the data and need to think about what the number format
would
be. I didn't have this problem with the earler version of excel (2003),
but
it started as soon as my office upgraded to 2007. Any ideas?