Claus Busch wrote:

Hi Terry,

Am Thu, 09 Oct 2014 11:35:03 +0100 schrieb Terry Pinnell:

I have a text file containing lines
3-01
3-02
3-03
etc

On copy/pasting these into an empty column (in Excel 2002) they were
displayed as

03-Jan
03-Feb
03-Mar
etc

3-01 is the short style to write a date.
Format your cells as text before pasting or open Excel = Data =
External Data from Text and choose in the 3. step of the assistent for
the expected column the format "Text"


Regards
Claus B.

Thanks both, appreciate the fast replies.

--
Terry, East Grinstead, UK