00:00In this video, I will guide you how you can write more than 10 digits in Excel.
00:08When you write 10 digits, the results will be appeared like this.
00:12So in the first method, is equal to text, bracket open, select the cell, comma, and quotation mark, double quotation mark.
00:27And put 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 digits and quotation mark and close the bracket and hit enter.
00:39And this is the, you can type 10 digits in Excel with the formula.
00:46In the second method, you need to put single quotation mark and type 10 digits.
00:521, 5, 4, 3, 6, 7, 8, 9, 0 and here, this is the method without formula.
01:03In the third method, right click and go to the format cell and here, you need to select text and click OK.
01:14And now type 10 digits and here, you can see that.
01:23And in the fourth method, select the cells, right click, go to the format cells and go to the customs and remove the general and type 10, 0, 3, 4, 5, 6, 7, 8, 9, 10.
01:39And this is the 10, 0 and hit enter.
01:43OK.
01:43And now type 10 digits.
01:49And here, you can see that.
01:53So with these three, four methods, you can easily write more than 10 digits in Excel.
Comments