excel enter phone numbers

Recently, I excel in the cell inside the input they are 134365440.00 No.13436544000, 8778860 enter 87788.60 is how they are going on, how should I set it? Before I used to set the cell format will not work, please let me know the next …Thank you approach …………..

selected cell, right Format Cells – digital –

text can be set up in the cell has a number of settings, he set the general format would be enough.Format Cells – digital – to select text
value but also have the option to choose small-hundred and the simplest way is to enter a pre-fight 'single quotation marks, followed by digital, single quotation marks will not show ha ha, the cell into a text format on the line.That's cells Setting the issue, set to resume in the worksheet cells in the upper left corner of the gray box hit the left — right-click Format Cells — in the “digital” option is set to carry conventional.Is set up like cell Format:
format – the cell – the number – the text is about to set the cell format:
format – cell – number – enter the text to add ” '” will be able to input cards By the same token, you also have entered the numbers, set up in the cell format, if not change, then double-check this, the grid will change in content, the cell may be prompted to enter the text type Figures like that in the upper left corner, the point you can ignore the error.There are typed in English before the state of the single quotation marks, the default is to enter the text you talk about is the automatic choice to set the decimal point Option, “Tools ? Options ? edit” the abolition of the “automatic settings decimal point” check.
In addition to input the telephone number, to general cell formatting text into the future and transported, Otherwise, the median length format error prone.The use of the decimal point is automatically set;
closed:Tools – Options canceled automatically set up in front of the decimal point ?

Leave a Reply