mattclements/excel-pad.txt

Created April 11, 2012 11:19

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/mattclements/2358703.js"></script>
Save mattclements/2358703 to your computer and use it in GitHub Desktop.

Download ZIP

Excel Pad with Leading 0's

Raw

excel-pad.txt

	#Account Number
	=REPT(0,8-LEN(A1))&A1

	#Sort Code
	=REPT(0,6-LEN(A1))&A1

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