Pasting into excel but formats as a date....

[AugustusHaynes]

Hi,

I've got a large table of data that I'd like to paste into excel. When I do so it picks up one column as dates but I don't want it to be formatted that way.

So for example it says 2/44 in a column and it will format it as Feb-44.

Firstly - what format should I use?

Secondly - is there a way to paste the entire table and it pick it up correctly? I've tried pasting into notepad then into excel but this same problem occurs.

Every other column looks perfect, it's just this one problematic one. When I look at the cell value it makes no sense either, comes across as 01/02/1944 so it's actually adding data from the original 2/44 value that I want to appear.


Thanks in advance

 

[Snakehips]

AH,

It sounds as if you can easily identify which column is giving you issue so to overcome this manually.... prior to pasting, select that column and format as text.

Hope that helps.

 

[AugustusHaynes]

simple but hugely helpful. I knew I was missing something.

Thank you very much for your help.