Hi everyone. In column B I have a list of numbers. Each number
varies in length, but no number is longer than 6 cbaracters. I need a
formula that will make each number rxactly 6 characters by attaching
leading zeroes to the FRONT if the number is less than 6 characters,
or do nothing if the number is already 6 characters. The "number" can
be converted to text.

Thanks!