Whenever I populate a numeric value into a cell, the leading zeros are always
removed even when I create a custom format. Excel thinks its a number but I
want to treate it as a character because I have to FTP the file to a
mainframe. I always get the warning that it contains some features not
compatible with CSV

Example, when I put 012345 in a cell, when I save it and then re-open it, it
contains 12345. I need it to be 012345 because the machine I am FTP'ing the
file too has this column formatted as *char 6, so I need it to end up as
'012345' not '12345 '. I can't save it as .xls because I can't FTP an .xls
file to another box and and use it in another application.