No csv format in Paste Special

D

dborski

For some reason I don't have the option to choose a csv format whe
using Paste Special to copy data into excel. I'm using Excel 2000 ve
9.0.3821 Sr-1.

I know that csv it is available because my coworkers have it.

Does anyone know how to add the csv option
 
J

Jim Rech

There is no CSV option in the Paste Special dialog for Excel. However,
sometimes a paste will wind up parsing text for the reason explained in this
article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;127132

--
Jim
message |
| For some reason I don't have the option to choose a csv format when
| using Paste Special to copy data into excel. I'm using Excel 2000 ver
| 9.0.3821 Sr-1.
|
| I know that csv it is available because my coworkers have it.
|
| Does anyone know how to add the csv option?
|
|
| --
| dborski
| ------------------------------------------------------------------------
| dborski's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=25918
| View this thread: http://www.excelforum.com/showthread.php?threadid=392913
|
 
D

dborski

Thank you for your reply. You are correct in that there is no cs
option on the initial "paste special" screen, but there is anothe
"paste special" screen that comes up when there is a certain type o
data in the clipboard. This screen has options as to what format yo
want to paste the data to. The options I have now are "bitmap"
"Unicode text", and "text". I need to find out how to add csv to tha
list
 
Top