How can I add a zero before a number in excel?
How to Add Zeros to a Range in Excel Select the range that you want to add zeros before the numbers or text. In the Add Text dialog box, enter the number of zeros with a leading apostrophe in the Text box, and select the Before first character option, then click Ok See More . …
