Hi,

Not sure whether you can preserve the formatting. If you check the data
series after breaking the link the numeric values of the dates is what
has been transfered not the formatted ones.

To fix it you need to double click the axis and set the Number format to
be the same as the cells where the data originally came from.

Cheers
Andy

WhytheQ wrote:
(this is Excel 2003)

We have a graph in BookA.
When I open BookA the format of the dates on the X axis are
01-Jan-2006.
When I use EditLinksBreak Link to BookB, the dates on the graph
revert to a general integer: 38718

Any one ever encountered this befo any ideas how to preserve the
format?

Any help greatly appreciated,
Jason


--

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