When manually entering data or copying them from external sources, the spreadsheet editor Microsoft Office Excel independently determines the format - text, numeric, date. He does not always manage to do it correctly, and sometimes the user himself needs to mislead the program and change the format of a group of cells. There are several ways to make numerical data text in Excel, for example.
It is necessary
Tabular editor Microsoft Office Excel 2007 or 2010
Instructions
Step 1
Start Excel, load the desired spreadsheet into it, and select the cells you want to format. Most often, this operation needs to be applied to cells of one row or column, to select which it is enough to click the heading of this horizontal or vertical row.
Step 2
In the "Number" group of commands on the "Home" tab, open the topmost control element - the drop-down list. Scroll down the list of formats and select the penultimate line - "Text" - and the format of the selected group of cells will change.
Step 3
The same can be done in another way. After selecting the desired area, right-click on it and select the "Format cells" line in the pop-up context menu. Excel will open a separate preferences window on the Number tab. In the "Number Formats" list, select the "Text" line and click OK.
Step 4
You can also use the “Text” function built into the spreadsheet editor - this is convenient if you need to convert the format in separately selected cells, or the text should be part of some formula, or you need to make text combine values from several cells, etc. In the simplest case, proceed as follows: start by highlighting the cell in which you want to display a numeric value in text format. Then, on the Formulas tab, in the Function Library command group, expand the Text list and select TEXT.
Step 5
In the "Value" field of the launched function creation wizard, specify the address of the cell to be converted - type it from the keyboard or click the cell with the mouse. In the Format box, enter a format mask. For example, if you put 0 in this field, there will be no decimal places in the final number, even if they are in the original cell. Mask 0, 0 corresponds to a number with one decimal place, mask 0, 00 - with two, etc. These rules apply if a comma is specified as the decimal separator in Excel preferences. With these settings, if you enter a mask such as 0.0 in this field, Excel will divide the original number by 10 before converting its format. With a mask of 0.00, the number will be divided by 100, etc.
Step 6
Click OK on the New Formula Wizard dialog box, and the cell displays the text equivalent of the original number format value.
