当您在工作表的单元格中输入信息时，您可能想知道Excel如何转换输入的内容。 Excel首先尝试将信息转换为数字。数字就是这样-任何数字（0到9），可以选择使用特殊字符。这些特殊字符中最常见的是句点（以小数点表示），数字之间的逗号，减号或加号以及数字后的百分号。如果使用百分号，Excel会假定您输入一个百分号，从而将数字除以100以进行内部存储。

也可以使用其他特殊字符。例如，如果您在数字前加一个美元符号，则Excel会假定您正在输入货币金额。您也可以输入用括号括起来的数字，例如（123），这是表示负数的另一种方式。斜杠（/）可用于表示分数或日期。最后，您可以使用字母E（大写或小写）表示您正在以科学计数法输入数字。下表总结了所有这些不同的数字和符号：

Symbol

Meaning

—

If used before a number or after a number followed by the letter

E (as in 123E—45), it is taken as a negative sign. If entered between

numbers, assumed first to be a date separator, unless the numbers are

illegal for a date; in which case it is considered text. If entered

after a number, then the entry is assumed to be text.

+

If used before a number or after a number followed by the letter

E (as in 123E+45), it is ignored. If entered between or after numbers,

it is considered text.

()

When completely surrounding a number, assumed to be a negative

sign. In all other instances (except in formulas), assumed to be text.

,

When followed by at least three digits, assumed to be a hundreds

separator. In all other instances, assumed to be text.

/

If entered between numbers, assumed first to be a date

separator—provided the numbers can be translated to a valid date. If

entered between numbers after a space (as in 2 1/4), tries to convert

the fraction to a decimal value. In all other instances, assumed to be

text.

$

When preceding digits, assumed to indicate that the number

represents currency. In all other instances, assumed to be text.

%

When following digits, assumed to indicate that the number

represents a percentage. In all other instances, assumed to be text.

.

When used once within an entry, assumed to be a decimal point. In

all other instances, assumed to be text.

E or e

When used once within an entry, assumed to indicate that the

number is being entered in scientific notation. The value to the left of

the E is normalized to between 1 and 10, and the value to the right is

used to represent the power to which the value is raised.

请记住，当您在数字中使用符号时，它们必须有意义。例如，您不能输入两个小数点或两个百分号，并且不能期望Excel理解您在做什么。如果您尝试输入这样一个荒谬的数字，Excel可能会假设您正在输入文本。

_ExcelTips_是您进行经济高效的Microsoft Excel培训的来源。

本技巧（11114）适用于Office 365中的Microsoft Excel 2007、2010、2013、2016、2019和Excel。您可以在此处为Excel的较早菜单界面找到此技巧的版本：

在Excel中输入数字。