Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Dates
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Two sheets | Charts and Charting in Excel | |||
Problem with date base units for x axis | Charts and Charting in Excel | |||
the dates to label the x axis on the scatter chart won't print | Charts and Charting in Excel | |||
How can I hide points for future dates on a Year to Date chart? | Charts and Charting in Excel |