Chaps,

Auto-generated report output gives text values for month and year in
yyyymmformat, e.g. Jan 2007 is 200701

Problem is these are text.

How can I get Excel to recognise this as a date?

I've tried YEAR(the text) and get something hideous.

I've tried LEFT(the text,4) to get the year out as 2007, but this is still
seen as text. e.g. if I try YEAR(the 2007 output), I get 1905...

I really should know better, but have been trying to get this working for
ages.

Any thoughts would be greatly appreciated.

Cheers.

Tom.

e.g. if I try