Formating issue after copy/paste

[david.rougier]

Hi everyone,

I have copied the following table from a mail and then I have pasted it into an Excel sheet :
Tableau Mail.png

Here is the result in my Excel sheet :
Tableau Excel.png

Values in the first and in the second columns have been automatically formated in scientific notation.
I do not want to format any values.
I want my table to be the same as it is in the mail.
What I need to do to achieve my goal ?

Thanks in advance

[martindwilson]

try formatting sheet as text first ,then paste

[david.rougier]

Thank you for your answer.

Here is how I have resolved my problem :
- I have applied the custom format @ on all cells before pasting
- I have pasted the table into the sheet
- I have chosen to respect the destination formatting in the pasting context menu