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

How about using a helper column of cells that converts your values to text and
then delete the original column:

=text(b2*100,"00000000000")

Drag down the column
select that range
edit|copy
edit|paste special|values

And delete the original column.

Another option would be to give that column a custom number format:

000000000\0\0



teleflora wrote:
>
> 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

--

Dave Peterson

"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> Another option would be to give that column a custom number format:
>
> 000000000\0\0
>

Genius! It worked.

Thank you so much.

Cindy