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

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

coldplay.xixi
Release: 2020-08-07 14:10:35
Original
47319 people have browsed it

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.

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

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.

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

#2. Paste the copied cell to the new cell location. You can see that the cell data has changed.

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

#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.

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

#4. You can paste the copied cell data into a new cell and the data will not change.

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

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template