-
Solved: Formula Problem
All
I have a list with a set of numbers as follows
11
23
34
45
345
234
566
4565
and so on
what i need to be able to do is make a column where all are 4 digits long with 0's in form of shorter strings, i also need to add a comma to the end of each one
eg
0011,
0034,
0345,
4565,
I changed by cells to text so i can get the leading 0's but can anyone point me in the right direction of a formula to do the above please (or VBA if easier)
Thanks GIBBO
-
-
Self Defined Format: 000#","
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules