Dates

[Andy]

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

 

[Jon Peltier]

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/
_______