Insert Values in Excel – Insert Text in Excel

Please follow and like us:

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.

Parenthesis

To interpret a negative number you have to insert a value (positive) enclosed in parentheses

Negative Values with Parentheses

Percentage sign

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.

Percentage Values Symbol in Excel

In this example, when you press the Enter key, the real value of the cell will be 0.15 and 15% will be displayed.

Currency symbol

If a value is preceded by the currency symbol, then Excel will interpret it as a monetary value. Then give it the corresponding format.

Currency Values Symbol in Excel

After pressing the Enter key, the contents of the cell shown in the formula bar will no longer include the currency symbol.

Thousands separator

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

Thousand Values Separator in Excel

Scientific notation

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

Entering text

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:

Please follow and like us:

Deja un comentario

Tu dirección de correo electrónico no será publicada. Los campos necesarios están marcados *