gerep/append-zeroes.txt

Created November 14, 2017 13:27

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

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

Download ZIP

Append zeroes to CPF numbers with < 11 characters on LibreOffice

Raw

append-zeroes.txt

	=IF(LEN(A1) < 11,CONCAT(REPT(0,11 - LEN(A1)), A1),A1)

	=IF(LEN(A1) < 11,
	CONCAT(
	REPT(0,11 - LEN(A1)
	),
	A1),
	A1)

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