small cell excel write, how to get rid of?
[Users questions | Browse:65 | Favorites]
Users questions: Is a set of numbers, but preceded by a small charge, is the punctuation of the written, but in the superscript position, regardless of use alternate methods to use, and especially the strange thing is, for example, where the mouse should only be displayed . Because too much, so if you manually delete do not know how much days to finish. Please advise, thank Thank! 7,777,771, enter "'", then enter the digital, which is text format string input methods. If we digital "'000051003235 'remove the upper left corner of the comma, before the four significant digits" 0 "will disappear and become" 51003235 "(which can be Remove the comma test bar to be verified). This is contrary to the intention of the importer. Therefore, the comma should not be arbitrarily removed! 2, if the text of the decision, "'000051003235" to numeric format of "51003235", the methods are: 1) Copy a blank cell, Change the format of the data to be selected, "Paste * operator * plus * OK." 2) In the free cell type "1", copy, change the format of the data to be selected, "Paste Special * op * by * OK." 3) change the format of the data to be selected, "points out the data * * * Next * Next End Into. "3, to maintain" 000051003235 ", and does not show the original left corner of the comma, you can: 1) the above step 2 of the first one of the three operations, the" '000051003235 "to" 51003235. "2) Select the changed data, "Grid -Style * cell * number * Category * Custom ", the right side of the interface type box enter" 0000 ########", can be determined. For reference.
- There are several new methods of presentation, simply out of.
- What word in how to increase the special symbols
- excel how to filter and distinguish between the number of consecutive
- How will the characters in the cell and breakdown of figures show?
- How to set excel in the integer "0" format
- How to convert PDF text editable word or TXT
- How could such a problem?
- Help explain, EXCEL function of usage, there are accessories.
- Why not let me see My Network Places?
- EXCEL delivery table and more, how do
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.