In cell B7 you could place the following: Let's say you have the value 6789 in cell A7. Excel displays the Paste Special dialog box.Īnother thing you can do is to use the TEXT worksheet function. Choose Paste Special from the Edit menu.This copies the cells you selected in step 1. In the list of formatting Categories, choose Text.The Number tab of the Format Cells dialog box. (To display the dialog box in Excel 2007, display the Home tab of the ribbon, click Format in the Cells group, and then choose Format Cells.) Excel displays the Format Cells dialog box. There is another thing you can try, however: In some versions it will work as described here, but in others it may not. The applicability of this solution, however, depends on the version of Excel you are using. Any selected cells are then formatted as if they were text, and are moved to the left side of their cells (unless you have some other alignment format specified). Display the Format Cells dialog box and then on the Number tab make sure that Text is selected. One way is to simply specify to Excel that the cells should be treated as text.
There are multiple ways that you can approach this problem. For instance, to convert the numeric value 6789 to the text digits "6789." Jocelyn asked if there is a way to easily convert numbers to their text equivalent.
0 kommentar(er)
