Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 46
Default Changing the date format on the date table in a chart

Hi, I have a data table under a chart, and the dates inside the table are in
the format of dd/mm/yyyy but I need to change them to dd/mm/yy. I cant see
how to do this. can you help please?

thank you
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 74
Default Changing the date format on the date table in a chart

If you select the column that has the dates in them and right click, format
cells, Date and pick the format that you would like. This should be all you
need.

Tim

"spudsnruf" wrote:

Hi, I have a data table under a chart, and the dates inside the table are in
the format of dd/mm/yyyy but I need to change them to dd/mm/yy. I cant see
how to do this. can you help please?

thank you

  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 46
Default Changing the date format on the date table in a chart

Yep. that did it. Thanks v much.

"tpeter" wrote:

If you select the column that has the dates in them and right click, format
cells, Date and pick the format that you would like. This should be all you
need.

Tim

"spudsnruf" wrote:

Hi, I have a data table under a chart, and the dates inside the table are in
the format of dd/mm/yyyy but I need to change them to dd/mm/yy. I cant see
how to do this. can you help please?

thank you

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
mm:ss keeps changing to a date format DavARei Excel Discussion (Misc queries) 7 February 27th 09 02:31 PM
date format keeps changing Carrie Excel Discussion (Misc queries) 5 August 12th 08 10:31 PM
changing date format Julie Excel Worksheet Functions 12 May 2nd 08 10:20 PM
Error in date format of first Pivot table chart OveBonde Charts and Charting in Excel 0 April 7th 08 12:23 PM
Changing Date Format stittal Excel Worksheet Functions 5 October 24th 05 07:49 PM


All times are GMT +1. The time now is 11:00 AM.

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"