Short / long date format bug?

B

Bill Ridgeway

The computer is set to use the long date format and everything is OK until I
make changes to a chart which causes all dates in all open worksheets to be
displayed in the short date format. When excel is closed down and restarted
the problem is resolved - but doing this is annoying.

I can't see if this a known fault or if it has been introduced through a
patch.

Does anyone know anything about this strange behaviour please?

Thanks.

Bill Ridgeway
 
B

Bill Ridgeway

Since posting this I haven't had one response. I can't believe I'm the only
user experiencing this problem. Every time I make a change to a chart *all*
dates in all open worksheets change from the (configured) long date (4 digit
year) to a short date format (2 digit year). If it isn't a bug just what
may be causing this problem please.

Thanks.

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

Date format changes 5
Default date format 4
Excel How to change the "Short Date" format in Excel? 4
Date Format Problem. 2
Why can't I convert Long date format to Short date 1
Date formats in Excel 2003 under Vista 5
Excel format in selected cells have changed to DATE format!!!! 2
A03- Date format in tables? 1

Top