Lost format after pasting

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.