answersLogoWhite

0

You use the apostrophe, like this:

'55

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

A rectangle where you can enter text numbers or formulas?

A cell.


To move from cell to cell across s table as you enter text press?

To get from cell to cell across a table as you enter text, press enter.


What key is used with the ENTER key to wrap text in a cell?

ALT key


What button lets you copy text into a cell instead of inserting the next higher number?

You can type whatever you want into a cell. You do not have to enter numbers.


What commod is used in excel to display text in multiple lines?

You could be referring to the Wrap Text command or to using Alt + Enter to enable text to be wrapped in a cell at the point that key combination is used.You could be referring to the Wrap Text command or to using Alt + Enter to enable text to be wrapped in a cell at the point that key combination is used.You could be referring to the Wrap Text command or to using Alt + Enter to enable text to be wrapped in a cell at the point that key combination is used.You could be referring to the Wrap Text command or to using Alt + Enter to enable text to be wrapped in a cell at the point that key combination is used.You could be referring to the Wrap Text command or to using Alt + Enter to enable text to be wrapped in a cell at the point that key combination is used.You could be referring to the Wrap Text command or to using Alt + Enter to enable text to be wrapped in a cell at the point that key combination is used.You could be referring to the Wrap Text command or to using Alt + Enter to enable text to be wrapped in a cell at the point that key combination is used.You could be referring to the Wrap Text command or to using Alt + Enter to enable text to be wrapped in a cell at the point that key combination is used.You could be referring to the Wrap Text command or to using Alt + Enter to enable text to be wrapped in a cell at the point that key combination is used.You could be referring to the Wrap Text command or to using Alt + Enter to enable text to be wrapped in a cell at the point that key combination is used.You could be referring to the Wrap Text command or to using Alt + Enter to enable text to be wrapped in a cell at the point that key combination is used.


What are the three types of information you can enter into cells?

text, numbers, and formulas


How do you move back from cell to cell as you enter text in a table?

After you enter your text you press Enter to move to the next cell down or Tab to move one cell to the right. Otherwise, you can use the arrow keys to manauver between cells.


How do you multiply cells with text and numbers in excel?

Normally, you do not. I recommend you put text and numbers in separate cells. You can modify the width of columns and join cells to format almost unlimited layouts on a spreadsheet, so there is no reason why you need to combine text and numbers in the same cell. Another option, is to enter the numbers as a separate entry in another column. You can hide the column, so the numbers do not show in the view or a printed report. If you have an absolute requirement to combine text and numbers in a cell, you can extract the numbers with a custom macro. The algorithm would be to cycle through all the characters of the cell and save only those characters that are numbers, then copy the numbers to a separate cell where you can perform calculations.


When would you enter numbers as text?

Whenever you want the numbers to be treated as text instead of numbers. Some examples are phone number, credit card numbers, and zip codes. A zip code can be a problem if you enter it as a number, because Excel will drop the leading zero from a zip code if the cell is formatted for a number. 09173 becomes 9173; not the same thing.


What is alphanumeric or text database?

A field of this data type will accept both numbers and text. The alphanumeric keys are the part of the deyboard that looks like a typewriter. When to use - it you want to enter text, or a mixture of text and numbers. When NOT to use - if you want to store only munbers, or only dates. You can enter numbers or dates into text fields but they would get sorted as if they were words and could not easily be used for any calculations.


How do you enter a series of numerical digits into a cell so that they are treated as text?

Start the entry with an apostrophe or format the cell as text.


How do you fit words in the cell box in excel?

This question is not clear. To enter text in a cell, click on the cell and type your text. If the text is too long to display in the cell, you can make the column wide enough to display the text. Another option is to format the cell to wrap text.