Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
converting dates from file
4 views
Skip to first unread message
colmkav
May 21, 2012, 6:57:35 AM5/21/12
to
Hi,
I am receiving dates in an excel file that appear to be in format m-dd-
yyyy format. When I execute the formulas day() and month() they get
them the wrong way round ie the month returns the day and vice versa.
Can someone tell me how I get around this problem and why its
occuring?
regards
Colm.
I am receiving dates in an excel file that appear to be in format m-dd-
yyyy format. When I execute the formulas day() and month() they get
them the wrong way round ie the month returns the day and vice versa.
Can someone tell me how I get around this problem and why its
occuring?
regards
Colm.
James Ravenswood
May 21, 2012, 11:01:16 AM5/21/12
to
joeu2004
May 21, 2012, 1:54:12 PM5/21/12
to
> in format m-dd-yyyy format. When I execute the formulas
Language Options control panel.
To convert the m-dd-yyyy form to correct numeric Excel dates, use the
Text-To-Columns feature. Be sure to click on Next, not Finish, in each
dialog box. When you get to the last dialog box, click on Date MDY to
convert the dates.
You might also need to format the cells as Date with the desired subtype,
for example d-mm-yyyy.
> day() and month() they get them the wrong way round ie
> the month returns the day and vice versa.
It appears that your date form is set to d-M-yyyy in the Regional and
> the month returns the day and vice versa.
Language Options control panel.
To convert the m-dd-yyyy form to correct numeric Excel dates, use the
Text-To-Columns feature. Be sure to click on Next, not Finish, in each
dialog box. When you get to the last dialog box, click on Date MDY to
convert the dates.
You might also need to format the cells as Date with the desired subtype,
for example d-mm-yyyy.
colmkav
May 21, 2012, 2:22:32 PM5/21/12
to
thx
0 new messages