How to add zero in Excel when normally when you enter a number Excel will automatically remove the zero if it is the first. This is because in math the leading zero means nothing. Not only that, when you enter a 0 right after the dot or date in Excel the number 0 will also be omitted? Together GhienCongListen learn about how to add zeros in excel in this article.
How to add zeros in Excel at the beginning
Way 1: is the simplest way, you need to format the input cell by adding a comma and then enter the number. However, the result of the text string will be non-numeric, numeric formulas cannot be applied and used for calculations.
Advertisement
Method 2: As shared above, Excel defaults to a number if the leading zero has no meaning. Therefore, you just need to change the number form to text and the number 0 will be preserved.
Advertisement
Here’s how to do it:
- In Home page (Home tab) please find the item Number group. The option bar will drop down, please select the item Text.
Advertisement
- As soon as you enter a number that starts with zero, Excel displays a small green triangle in the top left corner of the cell indicating this is invalid. To remove the triangle, select one or more cells of interest, click the warning sign, then select Ignore Error.
These are the two simplest ways to add zeros in Excel to the beginning of the cell.
How to add zeros after the dot in Excel
Similar to removing the first zero, after the dot will be the decimal part. If you leave only zeros (Example: 3.0), the calculator will default to zeros (Because 3.0 = 3). For some machines, you can type 3.0 normally, but 3.0 will get the same error. This is because of your computer format, the decimal part will be after the comma.
All you need to do is convert the cell you are typing into Text, then you can easily add a 0 after the dot.
- In Home page (Home tab) please find the item Number group. The option bar will drop down, please select the item Text.
If you see an exclamation mark next to the cell you just entered and want to remove it, click it and select Ignore Error when the submenu bar pops up.
How to add zeros to dates in Excel
For how to add zero in Excel to the date, the steps are as follows:
- First you select the data area to convert, right-click and select Format Cells.
- In the Number section, select down Custom. Then enter the format dd/MM/yyyy in the box Type same picture.
- Then press OK and you will see the date reformatted.
See more:
Above is all the content on the topic of how to add zeros in Excel. Hope this little tip is helpful to you. Don’t forget to Like and Share the article so that GhienCongListen has more motivation to make more quality articles.
Source: 3 fastest ways to add zeros in Excel that office workers should not ignore
– TechtipsnReview