Can you not just goto Format>Cells..., pick Custom Format and enter 00000000?
what is the best way to convert numbers to text and insert leading zeros at the same time? Columns of numbers to insert leading zeros and change to text:
I want them all to end up 8 digits, padding the front with zeros as needed.
I tried data, text to columns, but how can I insert the zeros? (large files)
There are currently 1 users browsing this thread. (0 members and 1 guests)