Allow LEN() in the TEXT() formula for automatic format_text
Please consider allowing the ability to use LEN() when determining the formattext input of the TEXT() formula. For example, let's say I have a column of ID numbers that are saved as numbers and I want to convert them to text. Using the TEXT() formula is great, but what happens when I don't know the length of the ID number? It would be great to be able to specify that I want to repeat "0" for formattext the number of times LEN() returns from the ID number in A2. Does that make sense? Thank you!