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.

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.

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.

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.