Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I'm copying and pasting Cisco port informaton: 2/11, 2/4, 3/10
I'm trying to copy and paste Cisco switch port information in to Excel and to
be able to sort the port information so it looks like 2/1, 2/2, ...2/21, 2/22, etc. Excel treats my ports as dates and will not sort properly. |
#2
|
|||
|
|||
Some things to try.......
1. Can you copy and paste special as Text? 2. Pre-format the cells as Text before the copy/paste. 3. Can you manipulate the data before it leaves Cisco? 4. Copy/paste to Notepad first then save as a *.txt file then open that file in Excel. Gord Dibben Excel MVP On Wed, 16 Mar 2005 09:13:07 -0800, "bigmo29" wrote: I'm trying to copy and paste Cisco switch port information in to Excel and to be able to sort the port information so it looks like 2/1, 2/2, ...2/21, 2/22, etc. Excel treats my ports as dates and will not sort properly. |
#3
|
|||
|
|||
Gord,
Thank you for the ideas below. I'm off at the moment so I'll try this first thing in the morning. You've given me some ideas to try. "Gord Dibben" wrote: Some things to try....... 1. Can you copy and paste special as Text? 2. Pre-format the cells as Text before the copy/paste. 3. Can you manipulate the data before it leaves Cisco? 4. Copy/paste to Notepad first then save as a *.txt file then open that file in Excel. Gord Dibben Excel MVP On Wed, 16 Mar 2005 09:13:07 -0800, "bigmo29" wrote: I'm trying to copy and paste Cisco switch port information in to Excel and to be able to sort the port information so it looks like 2/1, 2/2, ...2/21, 2/22, etc. Excel treats my ports as dates and will not sort properly. |
#4
|
|||
|
|||
Good luck with one of them.
Gord On Wed, 16 Mar 2005 15:01:09 -0800, "bigmo29" wrote: Gord, Thank you for the ideas below. I'm off at the moment so I'll try this first thing in the morning. You've given me some ideas to try. "Gord Dibben" wrote: Some things to try....... 1. Can you copy and paste special as Text? 2. Pre-format the cells as Text before the copy/paste. 3. Can you manipulate the data before it leaves Cisco? 4. Copy/paste to Notepad first then save as a *.txt file then open that file in Excel. Gord Dibben Excel MVP On Wed, 16 Mar 2005 09:13:07 -0800, "bigmo29" wrote: I'm trying to copy and paste Cisco switch port information in to Excel and to be able to sort the port information so it looks like 2/1, 2/2, ...2/21, 2/22, etc. Excel treats my ports as dates and will not sort properly. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trouble copying and pasting a formula | Excel Discussion (Misc queries) | |||
Copying & Pasting Formula | Excel Discussion (Misc queries) | |||
Trouble copying and pasting a formula | Excel Worksheet Functions | |||
Copying and Pasting in dialog boxes | Excel Discussion (Misc queries) | |||
Copying & Pasting arrow help | Excel Discussion (Misc queries) |