Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date automatically swaps
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date automatically swaps
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. N1KO wrote: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date automatically swaps
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 "Dave Peterson" wrote: 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. N1KO wrote: 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date automatically swaps
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! N1KO wrote: 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 "Dave Peterson" wrote: 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. N1KO wrote: 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 -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically update date | Excel Worksheet Functions | |||
Automatically update a cell with a date based on anther cells date | Excel Discussion (Misc queries) | |||
how do i automatically change the day and date | Excel Worksheet Functions | |||
Automatically Add in 56days to the date | Excel Discussion (Misc queries) | |||
Automatically Insert DATE, so that DATE will NOT change | Excel Worksheet Functions |