Why are the numbers different when copied and pasted into a table in excel?

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!