• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 259
  • Last Modified:

Insert leading zeroes that were stripped out

Someone gave me a spread sheet that is screwed up.
The account numbers should all be 7 digits long, but the accounts that started with zero have been stripped of all zeroes .. he is an example
0111111 is now 111111
0011111 is now 11111
0001111 is now 1111
Is there a way of inserting the leading zeroes back into the cells?
1 Solution
Change to a Custom format of seven zeros (0000000)
TRSysAdminAuthor Commented:
You are the best Graham!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now