Andy -

Double click on the dates, click on the Number tab, and select the desired number
format.

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

Andy wrote:

when i pivot information into a chart it changes date
formation from MAR-2003 to 18/03/2003. how can i change
this back.

Thanks