answersLogoWhite

0

You can use the Format menu and pick Cells and then choose the text format. Another thing you can do is to type a single quote in first and then the number, and it will be treated as text, like this:

'100

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

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.


How do you move 1 degrees to 90 degrees on a alignment sheet on excel?

Rotating Text


What does a compustat do in a computer?

The numbers are stored as text in Excel (that_¾_s why you see this green part in the left upper corner). When you convert the text to numbers, you can get an even stranger number: 578.510.000.


Can rotate text counterclockwise by entering a number between 1 degree and 180 degree on the Alignment sheet in the Format Cells dialog box?

Yes, the Alignment sheet in the Format Cells dialog box allows you to rotate text counterclockwise by entering a number between 1 degree and 180 degrees. This feature is useful for customizing text orientation in Excel.


What terms describes explanatory text attached to a cell in an Excel sheet?

alpha


How do you use bahttext function to convert English text in excel?

It converts numbers to Thai text. So if you wanted the number 6 in Thai, you can do something like this: =BAHTTEXT(6) It does not convert actual text and it does not convert numbers to English text.


How can you keep the leftmost zeros in a cell when using the LEFT command in Excel 2010?

Convert it to text.


In excel to enter a number as text start the entry with a?

apostrophe


Can Excel recognize the following text 401AX21?

There is no reason why you cannot type that in. As there are letters in it, it will be treated by Excel as text.


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.


Can you rotate text counterclockwise by entering a number between 1 degree and 180 degree on the aligment sheet in the format cells dialog box?

In Excel it is between -90 deg and +90 deg.


In Microsoft Excel what is the meaning of Numeric?

number instead of a letter (text)