How to Add Leading Zeros in Excel Formula and Power Query

[@MrDhunpagla]

You are magical 👌👌👌 Thank you for sharing this ... awesome & time saving idea 🙏

[@LinethDelaCruz]

Thanks a lot 😊

[@kebincui]

Very good. Thanks for sharing

[@LinethDelaCruz]

Thank you too

[@theowemer5782]

A 4th solution is the layout of the cells. Set the custom properties of the cells in this case to 6 zeros.

[@LinethDelaCruz]

Thanks for sharing this solution :)