Excel table 0 at the beginning of the number shows no solution

Excel0 start number does not show how to do, the following small series brings two ways to solve this problem, interested friends to come and see.

method, single quotation marks Act

This is one of the most convenient way, you only need to add a 0 in front of single quotes' on it, this method is suitable for Occasionally enter the number starting with 0. If it is a large batch or an entire row or an entire column, even if an area needs to enter a number starting with 0, then the following method 2 can be used.


second method, formatting method setting unit

This method is by changing the default value of a cell format, we set the cell type can be a text, select You need to enter the numeric cell at the beginning of 0, then right-click and select “Set Cell Format" in the shortcut menu, then select “Text” in the “Number” tab.


sometimes in the input cells in real value, and there are a lot of intermediate results containing 0, sometimes really do not want these numbers including 0, that is, as long as it goes blank 0 At this time, we can achieve the following steps, select the menu bar's "Tools → Options" in the "View" tab, click Cancel & ldquo; 0 value & rdquo; before the option "“√&rdquo ;, after the determination, the value of the current work table with a value of 0 will all be displayed as blank, but if you need to display a value of 0 in a part of the cell, you can not use this method, because this method is for all units Set by the grid.