Why this paste result?
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
|