Date format

B

Bill Ridgeway

Every time I change the x and y ranges on ANY line graph generated from an
excel file the date format on ALL open files and ALL files opened
subsequently is changed from dd/mm/yyyy to dd/mm/yy. Although this is not a
permanent change (the format is correct on re-starting Excel) it is
annoying. Can anyone please suggest why this is happening and if it can be
remedied?

Thanks.

Bill Ridgeway
 
B

Bernard Liengme

What version of Excel (2007 or earlier)?
The problem is just with one file or any file that you make a chart?
When you 'change the ranges', what actions do you perform?
What you are observing is very odd
 
B

Bill Ridgeway

Thanks Bernie,

I've been using Excel 2003 for some years but this problem has appeared for
no apparent reason. It occurs when the scale of either the x or y axis is
changed in any file.

Bill Ridgeway
 

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

How to use/create code in MS Word to calculate age? 0
VBA - exporting serial letters to single documents 0
How to add day to PWA 2016 date format? 0
Date Formats 4
Date Format 10
How to enter a date in DD-MM-YYYY format 2
Forcing a date entry format of dd/mm/yyyy 1
Export Report with Graph to Excel error 2495 1

Top