This starts out as an Excel file that I've cut and pasted together
containing SS#'s and amounts.  I used a formula to get the dollar amounts. I
format the amount cell to currency, 0 decimal places.

I then have to format the spread sheet and then save it as a *.prn file so I
can upload it to another company.

For instance I have a " fee amount" cell that has "22" in it. I have to
customize the format so that it has 11 spaces, zero filled so there are no
spaces in the cell.  The end result looks like this: 00000000022

Now I'm told the cell needs to look like this: 00000002200

I changed the custom format to 9 space and went in and added 2 - 00's to the
end of every fee amount.

Short of doing this to 800 cells every quarter, can anyone think of a way to
customize my cell to add the zeroes at the end of the line.

Maybe there would be a way for the original formula to give me a result of
2200, signifying $22.00?

Excel 2000.

Any help at all out there, please?

Thanks,
Cindy