This will allow us to improve the content. Microsoft 365, Microsoft Office, Microsoft Word, Office 2007, Office 2010, Office 2013, Office 2016, Office 2019, Office 365, Office for Mac / Text Wrapping Breaks in Word. ![]() ![]() Your opinion is important to us!Do not hesitate to tell us what you think of this article using the comment field located at the bottom of the document. When you enter a long number, type a single quotation mark ( ') first in the cell, and then type the long number.įor example, type '1234567890123456789 and the quotation mark will not be displayed after you press ENTER. If you do not want to see the warning arrows, click the small arrow, and then click Ignore Error. (Be sure to set the cell format before you type the number) On the Number tab, select Text, and then click OK. Right-click target cell, and then click Format Cells. ![]() To work around this issue, use one of the following methods. Default number format in Excel is General therefore you can display up to 11 digits in a cell.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |