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 enter a date in DD-MM-YYYY format 2
Converting date format 4
Forcing a date entry format of dd/mm/yyyy 1
convert date 1
Need help formatting a sheet 0
Form Control Calendar date will not change its format 1
Expiration date based on 5 years and Birth month,day ... 4
date format convert 2

Top