Shulou(Shulou.com)11/24 Report--

Hello, everyone. I'm Xiao Yin.

Recently, there are a lot of data files to sort out, and all kinds of operations make people have a big head.

This is not, copy and paste a data can also be a problem.

How come all the numbers have become E +?

Whoo-hoo-calm down, I can do it!

After some groping, I finally solved the problem.

Let's see what's going on.

First of all, let's figure out why "E +" appears:

When entering a number in Excel, if the number exceeds 11 digits, it will be automatically displayed in scientific counting, which is the so-called "E +" form.

So what should be done when pasting?

When the data length is 15, we need to operate before pasting the data.

PS. The data that has been pasted cannot be modified.

❶ select the range of cells to be pasted, and also press the shortcut key [Ctrl+1] to open the [format cells] pop-up box.

❷ select the text option in data-Classification, and then click OK.

Finally, just paste the data over.

How about these two tips, did you solve your data replication problem?

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: Xiaoyin, Editor: Yalizi

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.