Either format the cell as Text through the Format menu and Cells, or type a single quote before the value in the cell like this:
'5
In effect a cell in Excel is a box where either text, number or formula can be placed.
A cell is a rectangle that can hold a number, text, formula etc.
Format the cell as text. You also can input a formula: =text(A1) Remark: if the content is in cell A1.
text in a cell
If it is a number that is in the cell that is not wide enough, Excel will fill the cell with # symbols. If it is text in the cell, either the text will only show what can fit in it if the next cell has something in it, or it will spill out across the neighbouring cells if they are empty, though the text will not actually be in those neighbouring cells.
Right-click on the cell, select cell format and chose format numbers as text (Category: text). You also can begin the cell entry with an apostrophe (') to tell Excel to treat the cell contents as text.Make the first character in the call an apostrophe and Excel will treat the entry as text. EXAMPLE: '123
You can delete text in an Excel cell by pressing Backspace or highlighting the text and pressing Delete.
Right click on the cell then click on "format cells". Select 'text' under category on the NUMBER tab. click 'ok'.
Select the Cell and press Control + 1 or find format cell. Select the option under the "Number" tab "Text"
text means your writing, like a text box, you write in it! your welcome :)
If you have a cell the currently holds the text "friends," and you want it to combine a foumula and text in the same cell, here's an example: In cell A1 enter 23 (the number of friends you have). In cell A2 enter the following formula: ="You have " & A1 "friends." [You have 23 friends.] When you change the number in A1, you will see the number change in A2.
#name?