Andy, that doesn't work either. When I change the chart type to number, it
just remains as number.

I'm wondering what changed in 2007 that prevents a person from simply
entering in a date and having the date remain instead of going back to a
numerical sequence.

Thanks in advance.

"Andy Pope" wrote:

Hi,

My bad. Looks like they only fixed dates on line/column/bar charts and
not xy-scatter, which I assume is what your chart type is.

Looks like you will have to use a cell formatted as number to get the
correct value.

Cheers
Andy

jschultzbass wrote:
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?



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info