The solution when copying and pasting numbers into a table in Excel is different: First, right-click the cell that needs to be pasted; then select the [Paste Value] icon that opens the option; finally, paste the copied cell data Just go to a new cell.
Solution to solve the problem of different numbers after copying and pasting them into the table in excel:
1. First select what needs to be copied The pasted data cell has a formula.
#2. Paste the copied cell to the new cell location. You can see that the cell data has changed.
#3. At this time, you should right-click the cell that needs to be pasted and select the "Paste Value" icon to open the option.
#4. You can paste the copied cell data into a new cell and the data will not change.
Related learning recommendations: excel basic tutorial
The above is the detailed content of Why are the numbers different when copied and pasted into a table in excel?. For more information, please follow other related articles on the PHP Chinese website!