i need a macro that will take my numbers in column a and format them into column be 3 spots. so it its a single number it read 004, a two digit number reads 040, but if its a 3 digit number it just puts that number. Any help would be greatly appreciated.

Thanks




column A Column B

4 --------004
40------- 040
100------ 100
22------- 022

have you tried the ''custom'' format under the format menu?

Press Ctrl+1