#1   Report Post  
Andy
 
Posts: n/a
Default 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   Report Post  
Jon Peltier
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Two sheets David Charts and Charting in Excel 8 May 9th 07 09:29 PM
Problem with date base units for x axis Peter Carr Charts and Charting in Excel 1 December 15th 04 10:11 AM
the dates to label the x axis on the scatter chart won't print waterlady Charts and Charting in Excel 0 November 29th 04 07:44 PM
How can I hide points for future dates on a Year to Date chart? rlmills Charts and Charting in Excel 1 November 29th 04 06:23 PM


All times are GMT +1. The time now is 02:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"