It's because all dates where the days are greater than the 12th will come
out as text, there are a couple of ways to solve this, you can parse them
out using a formula or the easier way, make sure the column to the right of
the imports is empty, then select the column, do datatext to columns,
select delimited and click next, select space as delimiter, click next,
select the date column and under column data format in step 3 select date
and DMY (not MDY), then if you need the times click finish. That will give
you the time in one column and the dates in one, in a third column just add
them like in A1+B1 and copy down, then custom format as date and time. If
you don't need them, select the time column in step 3 and select do not
import and click finish

--


Regards,


Peo Sjoblom


"TDMP" wrote in message
...
Hi Luke that is the issue when using the Month function, I get a value
error
returned ..I assume its because excel is not understanding the month being
26/1/2009 ....I assume excel needs it to read 1/26/2009...does this make
sense? FYI this data is from a dump off a server in the UK so the dates
wil
come back in UK format...


"Luke M" wrote:

Assuming it is truly just the format that's causing the display (and not
text
inputted as a date) you can just use the MONTH and YEAR functions.

Example:
=MONTH(SerialDate)

See XL help file for further detail.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"TDMP" wrote:

Hello, I have a sheet that contains dates in column (W) formatted per
the UK

26/01/2009 12:45:37

In order to get the month and year, do I need to reformat them to US or
is
there another way to get the month and year correctly?

If so how do I do this?

Thank you