5+ How To Keep Leading Zero In Excel Trending. Saved the file as xlsx. Finally, press the ok button. Add or Keep Leading Zeros in Excel (10 Suitable Ways) ExcelDemy from www.exceldemy.com Below are the steps to remove leading zeros using text to columns: Right click and choose format cells. To run the code from …