In this new post of the Excel Tutorial your are going to learn about Values in Excel. When entering numeric digits in a cell, Excel interprets that you make entry as a value. In addition to the digits entered, the values may contain some symbols or signs. That will have an effect on their format or interpretation.
Positive and negative sign
To interpret a negative number you have to enter any value preceded by the negative sign (-). It is also possible to enter a value preceded by a positive sign, however, Excel will remove the symbol and interpret it as a positive number.
To interpret a negative number you have to insert a value (positive) enclosed in parentheses
If a value is preceded by the percentage sign. Excel will interpret that value as a percentage. Then automatically will apply a percentage format, which also implies that it will divide the numerical value by 100.
In this example, when you press the Enter key, the real value of the cell will be 0.15 and 15% will be displayed.
If a value is preceded by the currency symbol, then Excel will interpret it as a monetary value. Then give it the corresponding format.
After pressing the Enter key, the contents of the cell shown in the formula bar will no longer include the currency symbol.
If the entered value includes the thousand separator. Excel will interpret it as a numeric value and give it the appropriate format. After pressing the Enter key, the contents of the cell shown in the formula bar will not show the thousand separator.
Excel will interpret a value as a text, if the thousands separator isn’t located in the proper position. Its important to locate it in the right place
To interpret the value as if it were scientific notation you have to enter the value containing the letter “E”. To obtain the 5.8 x 103 value, you have to enter 5.8E3 in the cell
Everything that Excel can not interpret as a value, date, time or formula will interpret it as text. That is, everything that does not belong to the categories just mentioned will have a text format by default.
The only important thing to consider regarding a text is that a cell can only contain a maximum of 32,000 characters. That is a lot of information for a single cell. So much that you will have difficulty visualizing it on the screen.
It is preferable to use a text box located on the Insert tab within the Text group, if for some reason you need to place large amounts of text.
In the video below you can see a good example of adding Text into numerical Values: