Excel Date Format - Stop?

[Bob]

I have a table (from Word for example) that I want to copy/paste into excel.

Example:
ID Description
01-01 Item 1
02-01 Item 2
16-01 Item 3
17-01 Item 4

The format of the cells for items 1&2 ID field will always default to a date
- Excel will show "1-Jan" instead of the "01-01" that was in the original
table. If I change the format of the cells to text after pasting I get the
serial number value for the date. I can't get back to the 01-01 without
manually reentering the data. The pasting of items 3 & 4 will work without
error. How can I keep the data as shown in my original table?

 

[Gord Dibben]

Bob

Pre-format the cells in Excel to Text before the paste step.

Gord Dibben Excel MVP

 

[Bob]

Thanks for the reply. Pre-formatting does not fix the problem. "01-01" is
still pasted as "1-Jan" as an example...

 

[tjtjjtjt]

Paste Special | Text worked for me using Excel 2003.

I also was able to use the Paste Options Button to Match Destination
Formatting, if I had preformatted the cells as text. Paste Options pops up
directly after you Past in Excel 2002 or later.

tj

 

[Gord Dibben]

I copied your example text from the original post to an Excel sheet with
column A formatted as text.

The 01-01 and 02-01 copied in as such.

Hang in. Maybe someone else can supply a suggestion.

Gord

Thanks for the reply. Pre-formatting does not fix the problem. "01-01" is
still pasted as "1-Jan" as an example...

ID Description
01-01 Item 1
02-01 Item 2