=IF(LEFT(E2,1)="7",CONCAT("0",E2))
Created
August 3, 2017 10:17
-
-
Save neilbradley/d1f39ee97af9cfc96ee710a286c99fce to your computer and use it in GitHub Desktop.
Add leading Zero if a Number Starts with 7 in Google Sheets
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment