Is there a way to format cells to except leading zeros?
I'm using the "& A1 &" formula to help created a specific file format. The file format requires that some values require a certain length and if the value does not meet this length then the value should be proceeded by Zero.
Example: Require characters is 10, but the values is 7054. 7054 would be enter into the file format as 0000007054.
How can or can I format excel utilize leading zeros, other than making it a text cell because the value must be calculated?