Skip to content

Instantly share code, notes, and snippets.

@neilbradley

neilbradley/formula.md

Created August 3, 2017 10:17
Show Gist options
  • Save neilbradley/d1f39ee97af9cfc96ee710a286c99fce to your computer and use it in GitHub Desktop.
Save neilbradley/d1f39ee97af9cfc96ee710a286c99fce to your computer and use it in GitHub Desktop.
Download ZIP
Add leading Zero if a Number Starts with 7 in Google Sheets
Raw
formula.md

=IF(LEFT(E2,1)="7",CONCAT("0",E2))

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment