Date automatically swaps

  • Thread starter Thread starter N1KO
  • Start date Start date
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
 
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.
 
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.
 
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
 
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
 
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!
 
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!
 
Back
Top