如何将文本转换为数字？ [英] How to convert text to numbers?

问题描述

我有一个Excel报告，其中包含几列文本和几列数字，以文本形式存储。

I have an Excel report which contains several columns of text and several columns of numbers which are stored as text.

有没有一种简单的方法来转换那些作为文本存储在数字上，而不影响实际的文本数据？

Is there an easy way to convert those numbers that are stored as text to numbers, without affecting the actual text data?

推荐答案

我发现，最简单，最快速的转换方式以数字形式存储的数字为

I find that the easiest and quickest way to convert "numbers stored as text" into numeric numbers is

1. 选择任何空白单元格


2. 复制该单元格Ctrl + C）


3. 选择包含要转换的数据的范围（如果范围包括非数字数据也可以）


4. 使用粘贴特别与操作添加（我猜减也将工作）

1. Select any blank cell
2. Copy that cell (Ctrl+C)
3. Select the range which contains the data you want to convert (it's OK if the range includes nonnumeric data as well)
4. Use "Paste Special" with operation "add" (I guess "subtract" would work too)

除了快速，这有优势

粘贴专用位于Excel（2003及更早版本）的经典版本的编辑菜单中，或位于 E的丝带版本的主页标签xcel（2007 +）。

"Paste Special" is in the Edit menu of "classic" versions of Excel (2003 and earlier), or in the Clipboard section of the Home tab of "ribbon" versions of Excel (2007+).

这篇关于如何将文本转换为数字？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！