Custom Number

[teleflora]

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]

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]

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

000000000\0\0

Genius! It worked.

Thank you so much.

Cindy