阻止Excel评估单元格内容? [英] Stop Excel from evaluating cell contents?
问题描述
有没有一种方法可以阻止Excel 2010对一堆包含多个带有前导正负号的数字的单元格进行数学运算?例如
Is there a way to stop Excel 2010 from doing math on a bunch of cells containing multiple numbers with leading plus or minus signs? E.g.
-706795 -1456130 -1869550 -936304 -1729830 -1737860 -687165 -16807800
现在，它将数字加起来为一个值.我希望它们显示如上.将单元格设置为文本格式无效.我从CSV取得此数据，并且对其内容的控制有限...
Right now it sums the numbers up into one value. I would like them displayed as above. Formatting the cell as text doesn't work. I get this data from a CSV and have limited control over its contents...
推荐答案
使用文本导入向导将每个值加载到单独的列中.您可能必须将CSV文件重命名为".txt"，以默认情况下启动导入向导(在这里寻找无耻的代表:).
Use the text import wizard to load each value into an individual column. You may have to rename the CSV file as '.txt' to get the import wzard up by default, (shameless rep seeking here:).
这篇关于阻止Excel评估单元格内容?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
