停止Excel科学符号转换 [英] Stop Excel Scientific Notation Conversion

问题描述

是否可以停止EXCEL ，将数据转换为科学计数法?

Microsoft Excel显然假定任何包含数字和E的数据都应该是科学计数法并将其转换.

17195E000039 自动更改为 1.7195E + 43

17221E000112 自动更改为 1.7221E + 116

是否有一种方法可以防止Excel这样做，从而不会继续给我们从不希望使用科学表示法的所有用户带来麻烦?我无法预见任何时候，我将永远希望将任何东西转换成科学计数法.这种无用的功能只会导致问题.

如何在不先手动执行某些操作的情况下阻止Excel将文本转换为科学文本?

不幸的是，数据来自另一个系统，该系统可以导出到我无法更改的excel.我无法手动手动更改页面，而之后却很烂.

解决方案

是否有一种方法可以阻止EXCEL将数据转换为科学计数法?

@Scott Craner解释:

这是在写入数据时自动发生的事情-当您看到数据为时已晚.

Is there a way to STOP EXCEL from converting data into Scientific Notation?

Microsoft Excel apparently assumes that any data that contains numbers and an E is supposed to be scientific notation and converts it.

17195E000039 automatically changes to 1.7195E+43

17221E000112 automatically changes to 1.7221E+116

Is there a way to prevent Excel from doing this so it doesn't continue to cause problems for all of us users who never want to use SCIENTIFIC NOTATION ever? I cannot foresee any time where I will EVER want to have anything converted to scientific notation. This useless functionality only causes problems.

How do I stop Excel from trying to convert text into scientific without manually performing some operation first?

Unfortunately, the data comes from another system that exports to excel that I cannot change. I cannot manually change the page beforehand and going through afterwards sucks.

解决方案

Is there a way to STOP EXCEL from converting data into Scientific Notation?

As explained by @Scott Craner: For you, No.

This is something that happens automatically when the data is written - by the time you see it it is too late.

这篇关于停止Excel科学符号转换的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！