answersLogoWhite

0

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

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What are the functions of cells in Excel?

In effect a cell in Excel is a box where either text, number or formula can be placed.


What is cell in Microsoft office excel?

A cell is a rectangle that can hold a number, text, formula etc.


How do you convert the number into text in Microsoft Excel?

Format the cell as text. You also can input a formula: =text(A1) Remark: if the content is in cell A1.


What is the label in excel?

text in a cell


What appears in Excel when the cell isn't large enough?

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.


Text or numbers in a cell?

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


How delete text in cell?

You can delete text in an Excel cell by pressing Backspace or highlighting the text and pressing Delete.


How do you get Excel to stop automatically replacing stuff you write on the cells?

Right click on the cell then click on "format cells". Select 'text' under category on the NUMBER tab. click 'ok'.


How do you stop a number changing to a date in a cell in Microsoft Excel?

Select the Cell and press Control + 1 or find format cell. Select the option under the "Number" tab "Text"


What is meant by text in excel?

text means your writing, like a text box, you write in it! your welcome :)


How you can give formula in a cell excel in which text is already there?

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.


What appears in a cell formula includes text that excel?

#name?