I have an Excel file that has a column of cells that are formatted as text. This is a little confusing in that the characters are actually numbers but the column needs to remain formatted as text.
My issue however is that some of the cells contain 2 characters, others contain 6, 7, 8, 9 characters, etc.
I need to somehow make them 14 characters in length with zeroes in front of whatever is there already. So for example, 14 would become 00000000000014. Or another example would be 5623 would be 00000000005623, and so forth.
How can I convert these strings of character to include the zeroes in front of whatever is there already?
--Steve
Open in new window