[Resolve] Excel – Why Can't I See The "0" In My Excel Workbook?

You will find how make the "0"[Zero Number] to be seen in your Excel's cell(s) in our today's tip

If you are looking for what to fix the "0"[Zero Number] disappear when put at the beginning of the string of data entry.

Here I am going to share with you the 2 ways of solving such that kind of problem.

1] Simply put an apostrophe [ ' ] in front of the number like this '000666. This mode might show you an error message but won't make any wrong to the numbers.

2] To set the specific format at the "Custom" category.

This step below will show you how to make it done:

• Right click mouse, which is already onto the cell to be worked.

• Click on the tab "Format Cell..."

• On the "Number Tab" click the "Custom" that is usually at the lowest line from the Category list.

• To fill out the "0..." equal to the digit number as required in the Type: space box. Ex. type 000000 (6 digits) as for 000656.

• Click "OK" bottom at the below right corner of the "Format Cells Box"

Hope this article will be usful for you all.

Bye,
Michael leng

See more tips:

• Excel Trick to Make a New Unconventional Graph with “REPT ( )” Formula
• Trick How To Delete The Same Data In Multiple Places With An Easy Way
• Ctrl+Shift+_ Excel Shortcut Erase The Selected Lines Border Of Cells
• Removes Unwanted Spaces Leading, Trailing And Between Words From The Text String
• VLOOKUP Searches For Value From Table Array In The First Column Return Value The Same Row