Double click the text element that keeps changing its format. On the Number
tab of the Format dialog, uncheck the Linked to Source checkbox and select
an appropriate format. It should remain unchanged from now on.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Sue" wrote in message
...
I have a chart file that is linked to another file with the data. I cannot
get the chart file to keep the format that I want. I keeps changing to
show
decimals and no commas.

--
Accounting Manager