Hello!
I am trying to have a column of numbers include leading zeros so they all contain six digits.
Example Attached
1. I want all numbers Column A to have six digits (if they already have 5 digits, add 1 leading zero, 4 digits = 2 leading zeroes, and so on).
2. When I follow a website I found with tips for this process (highlight cells, format cells, category - custom, type 6 0's under type, click OK) - the format of the cell automatically changes to "Special", not custom).
3. Then, when I close the file and re-open it, the numbers are back to the original digits (4 or 2 or whatever) and not the 6 digits with the leading zeros.
Thank you for any help you can provide!
Doc1.docx
Bookmarks