3 Ways of Adding Leading Zeroes to Cell Values in Excel
When you paste a data into Excel, it looks for numbers – when found then it formats it by removing leading zeros.
If you want to keep the zeros set the type of data in cells to text before pasting.
When you already have values in Excel and you want to put leading zeros you have 3 ways of doing it.
There are fields that should have five characters with lead zeros padding out the string.
“32” should become “00032”,
“321” should become “00321”, and
“32198” should remain “32198”
Using TEXT function
Format cell as Number
Right click cell and choose Format Cells… or press CTRL + 1
Select Custom and in Type box enter 00000, click OK