Dates

A

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
 
J

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart For Hiring Plan 0
Conditional Formatting question.... 1
Problem formatting dates from CSV file 2
Project 2003 x vbs 1
Formatting pivot chart axis labels for dates 10
Excel does not accept text format! 0
Table of content - format does not get saved 2
Difficulty with compatibility mode and Track Changes 2

Top