I am trying to create a comma delimited file with each column haveing a
unique format. One column 9 digits, one column 9 digit dollar amount, one
column a specific date format with zero fill. I have found the discriptions
I on type..modify..number..custom..then the choice. When I choose the format
for the highlighted column it adjusts all the columns to a different format.
How do I keep the type unique to each column?

Let me clarify. The first column needs to have 10 numeric digits. If it is
less I need to zero fill the column. I have that part figured out. The
problem is when I highlight the first column and change the format style, all
the fields in the spreadsheet keep the same format type as the highlighted
column. I need to have several columns keep a different format type. One is
a 6 digit date format, another is a dollar format with 11 digits. When I try
to change the format type back to the date or dollar format, the whole
document changes. Is there something I am missing. Do I need to create
each field individually?

"CommerceMary" wrote:

I am trying to create a comma delimited file with each column haveing a
unique format. One column 9 digits, one column 9 digit dollar amount, one
column a specific date format with zero fill. I have found the discriptions
I on type..modify..number..custom..then the choice. When I choose the format
for the highlighted column it adjusts all the columns to a different format.
How do I keep the type unique to each column?