Excel, Accelerated: Retain leading zeroes in ID numbers Time: 2:41 | Would you like to know how to retain leading zeroes in ID numbers? To learn how, watch the video and download the Excel template. Techniques: TEXT, RIGHT, REPT, LEN, FIND Buy $4.99