PDA

View Full Version : Solved: Formula Problem



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

Bob Phillips
09-12-2006, 03:48 AM
=TEXT(A1,"0000\,")

Emily
09-12-2006, 03:56 AM
Self Defined Format: 000#","

gibbo1715
09-12-2006, 04:02 AM
Thanks, that sorted it