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
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
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.
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.
What terms describes explanatory text attached to a cell in an Excel sheet?
alpha
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.
How do you apply bold styles to text in a Microsoft Excel sheet generated by PHP?
The origin of the sheet usually doesn't matter. You can apply bold styles to PHP generated sheets as you would in any other sheet: right click the cell or text you want to make bold, and select the appropriate option to change font styles (which varies depending on your version of Microsoft Excel).
In Microsoft Excel what is the meaning of Numeric?
number instead of a letter (text)
