date format
in [General]
|
Prev: Extracting Data from a list into a schedule
Next: How to set Excel 2010 as default for open excel files instead of 2
From: pothios on 15 Mar 2010 21:25 Hi all, I have a problem with date formatting. i have the following dates in MM/DD/YYYY format: 4/1/2010 4/2/2010 04/15/2010 when i tried to re-format the date, the 1st 2 column is formatted sucessfully but the last date will always remain unchange no matter what format is selected. Can anyone please explain the reason for this issue?
From: pothios on 15 Mar 2010 21:37 resolved the problem by changing locale. "pothios" wrote: > Hi all, > > I have a problem with date formatting. > > i have the following dates in MM/DD/YYYY format: > 4/1/2010 > 4/2/2010 > 04/15/2010 > > when i tried to re-format the date, the 1st 2 column is formatted > sucessfully but the last date will always remain unchange no matter what > format is selected. Can anyone please explain the reason for this issue? >
From: "David Biddulph" groups [at] on 16 Mar 2010 02:38
Yes. As you will have now realised, if your Windows Regional Settings in Control Panel (not Excel) are expecting DMY, not MDY, then 04/15/2010 will be treated as text, not a date. -- David Biddulph "pothios" <pothios(a)discussions.microsoft.com> wrote in message news:FFFB57CA-FAAC-4E27-BE56-E48D23763EBF(a)microsoft.com... > resolved the problem by changing locale. > > "pothios" wrote: > >> Hi all, >> >> I have a problem with date formatting. >> >> i have the following dates in MM/DD/YYYY format: >> 4/1/2010 >> 4/2/2010 >> 04/15/2010 >> >> when i tried to re-format the date, the 1st 2 column is formatted >> sucessfully but the last date will always remain unchange no matter what >> format is selected. Can anyone please explain the reason for this issue? >> |