How paste numbers from email into excel without changing formulas in paste columns of excel

[Shreeprakash mishra]

How do i copy number from the daily count email and paste it into excel where daily production gets calculated without changing formulas.
E.g. i have tried all three copy paste options but still when i paste numbers in excel the formulas get edited automatically. And the total production goes to 100%.
Please assist.
What cell(s) are you pasting to? A to Z in vertical
What cells contain formulas? I guess the last cell in vertical row which sum up the total counts and create into percentage that how that x person has worked that day
What is "total production"? If it's not supposed to be 100%, what is it supposed to be? This is the last cell in table which sums up and should calculate how much percentage x has worked
E.g x has worked A - 20 C 30 F 15 G 10
Then last column the total sum of this number gets calculated automatically and gives us in percentage that out of 100% how much x has worked.
So when i receive email from x about his count i can't copy the numbers directly and paste in excel i have to put all the numbers manually bcz if i copy paste it then the total production doesn't get calculated and goes to 100% which us false error.

 

[Fluff]

Duplicate to: How to paste without changing formulas

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.