I have an array formula as follows:
The array of numbers from SEQUENCE run from 1 to 528, but I want all the numbers to have matching lengths.
Currently, Google Sheets strips out any leading zeros.
In other words, my formula returns
"NUMBER-528" but I want it to return