gibbo1715
09-12-2006, 03:26 AM
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
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