Lost format after pasting

**Raiby** · 10-11-2007, 02:27 AM

Hi all

I have two files: let's say File1 and File2.File1 has one column: datas are in a text format.I copy this column. I want to paste it in my second file.File2 is closed.I open it and i paste my column.
Here's my problem. If i let my first file opened, there's no problem(!!): my column is pasted as i want. My datas keep their original format.
But, if i close my first file and after, i open File2 and i paste my column, then my datas lose their original format.My column takes a numeric format.I can see it because my datas are on the left in the column.And i can chek it by a sum: if i do 400+200, for example, the result is 600. In the first case(text format), the result is 0.I don't understand why.If someone can explain me this situation, i'd be happy.I repeat: my second file is closed. I open it after my copy in the first file.

Thanks in advance for your help.

**tuph** · 10-11-2007, 08:02 PM

Try using Paste Special instead of just pasting. After you open file2, right click on the cell where you will paste and select Paste Special, click on the Values or Text option, then click OK. The pasted data will keep the format of the cell it is being pasted into, so it needs to be formatted before you paste.

**Raiby** · 10-12-2007, 02:35 AM

Originally Posted by tuph

Try using Paste Special instead of just pasting. After you open file2, right click on the cell where you will paste and select Paste Special, click on the Values or Text option, then click OK. The pasted data will keep the format of the cell it is being pasted into, so it needs to be formatted before you paste.

Hi Tuph

Thanks for your answer. I know your solution and i have tried it but my problem is that when i open the menu Paste Special, i don't see the menu with the following options: All, Formulas,Values,Formats, and so on. What i see in fact is a Paste Special dialog box with 2 options: Unicod Text and Text.I see also "Inserts the contents of the Clipboard as a unicode text". Anyway, when my first file is opened, my pasting is good.It doesn't work if i close my first file.It's strange. Isn't it?I try to be clear even i don't speak english.If you see my problem (i don't speak english very well), i wait your solution. Thanks again.

**ukphoenix** · 10-12-2007, 02:37 AM

Can u post a small example of what u are trying to do

**Raiby** · 10-12-2007, 07:38 AM

Originally Posted by ukphoenix

Can u post a small example of what u are trying to do

See my screenshots.

**Oscar** · 10-12-2007, 12:56 PM

Are your two files being opened in the same "Excel" environment?

I may not explain it right; but with Excel 2003, at least, you can open multiple workbooks in Excel or yo can also open a completely different Excel.