Ok. I am needing the cell to contain a maximum of 10 numbers. Sometimes I am provided 4 or 5 numbers. For example "1492" or "93823". What I am needing help with a formula that will add 5 or 6 "0" zeroes before those number sets. Any ideas. I have been playing around and still can't figure it out. Thanks.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Excel Formula Question
- Thread starter Ethanflux
- Start date
S.H.A.D.O.
Well-known Member
- Joined
- Sep 6, 2005
- Messages
- 1,915
Do you mean something like custom format "0000000000"?
Or if it is in the formula something like...
I hope this helps!
Or if it is in the formula something like...
Code:
=TEXT(A1,"0000000000")I hope this helps!
Last edited:
Upvote
0
I mean that they give me different numbers of different lengths. Such as "33929" or "392212" I need the formula to automatically make it "0000033929" or "0000392212". Where it is automatically putting 0 before the number but not going over 10 digits.
Upvote
0
S.H.A.D.O.
Well-known Member
- Joined
- Sep 6, 2005
- Messages
- 1,915
OK, can you post the formula that you are using please, then we can adapt using my second example above.
Upvote
0
