Hi, All
I have a number column, I want to format the numbers to length 6: For
example 456 change to 000456, 78 to 000078, 23456 to 023456. I tried to use
Format (A1,"######"), but it does not work. Please help how to use VBA to
format the column.

Thanks

kai