You will need to convert the cell to text to get it to stay the way you want
in the CSV file.

Either use an initial apostrophe in data entry (as in '012345). This forces
the entry to stay as text.

If it's a calculated field, use something like:

=text(a1,"000000")

Again, this will create a 6-character text field.

Regards,
Fred.

"GKW in GA" wrote in message
...
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.