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
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks