Solved: Formula Problem

[gibbo1715]

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

[Bob Phillips]

=TEXT(A1,"0000\,")

[Emily]

Self Defined Format: 000#","

[gibbo1715]

Thanks, that sorted it