Date automatically swaps

N

N1KO

I have an issue when I open excel sometimes the date moves from dd/mm/yyyy to
mm/dd/yyyy but according to the cell format it's still in the format
dd/mm/yyyy.

Does anyone else have this problem? If so can it be fixed or is it a bug in
excel.

Its causing major problems as it making figures extremely missleading.

Thanks in advance
 
D

Dave Peterson

Try changing the format to something unambiguous:
MMMM DD, YYYY

Then save and close and reopen a few times.

I bet your dates don't change at all.

My guess is that your dates weren't what you thought they were.

If you're importing the dates from a text file, make sure you choose the format
that matches the order of the original data (mdy or dmy or ...).

Then give the range an unambiguous format so you can check your imported data
against the dates in the text file.
 
D

Dave Peterson

Try changing the format to something unambiguous:
MMMM DD, YYYY

Then save and close and reopen a few times.

I bet your dates don't change at all.

My guess is that your dates weren't what you thought they were.

If you're importing the dates from a text file, make sure you choose the format
that matches the order of the original data (mdy or dmy or ...).

Then give the range an unambiguous format so you can check your imported data
against the dates in the text file.
 
N

N1KO

Hi Dave,

Thanks for this i'll try that, it's just wierd as when i import it from
various formats, (text, access, dbf, other excel)

It's extremely wierd.

Regards

Nick
 
N

N1KO

Hi Dave,

Thanks for this i'll try that, it's just wierd as when i import it from
various formats, (text, access, dbf, other excel)

It's extremely wierd.

Regards

Nick
 
D

Dave Peterson

If you can get your coworkers to switch to unambiguous date format, things get
lots easier.

But seeing a date like:
01/02/03
leaves way too much room for interpretation -- by a human and by a pc!
 
D

Dave Peterson

If you can get your coworkers to switch to unambiguous date format, things get
lots easier.

But seeing a date like:
01/02/03
leaves way too much room for interpretation -- by a human and by a pc!
 

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

Top