|
Excel Date Format - Stop?
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? |
Bob
Pre-format the cells in Excel to Text before the paste step. Gord Dibben Excel MVP On Mon, 10 Jan 2005 12:33:02 -0800, Bob wrote: 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? |
Thanks for the reply. Pre-formatting does not fix the problem. "01-01" is
still pasted as "1-Jan" as an example... "Gord Dibben" wrote: Bob Pre-format the cells in Excel to Text before the paste step. Gord Dibben Excel MVP On Mon, 10 Jan 2005 12:33:02 -0800, Bob wrote: 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? |
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 "Bob" wrote: Thanks for the reply. Pre-formatting does not fix the problem. "01-01" is still pasted as "1-Jan" as an example... "Gord Dibben" wrote: Bob Pre-format the cells in Excel to Text before the paste step. Gord Dibben Excel MVP On Mon, 10 Jan 2005 12:33:02 -0800, Bob wrote: 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? |
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 On Mon, 10 Jan 2005 14:37:07 -0800, Bob wrote: Thanks for the reply. Pre-formatting does not fix the problem. "01-01" is still pasted as "1-Jan" as an example... "Gord Dibben" wrote: Bob Pre-format the cells in Excel to Text before the paste step. Gord Dibben Excel MVP On Mon, 10 Jan 2005 12:33:02 -0800, Bob wrote: 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? |
| All times are GMT +1. The time now is 09:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com