For example, my input data file brings in the amount 72208.88. For the
submission file this entry needs to appear 000007220888
The decimal is implied and the amount needs to be right justified and zero
filled, with the column width at 12.

"bj" wrote:

> I also am not familiar with that format
>
> "Ron Rosenfeld" wrote:
>
> > On Mon, 18 Apr 2005 08:22:01 -0700, LAM <LAM@discussions.microsoft.com> wrote:
> >
> > >The column needs to be formatted numeric. This is a file that will be
> > >transmitted to the bank to verify Payables check amounts. It is called an
> > >ARP Standard Issue Input Format. If it is "Standard" I wonder why it is so
> > >difficult to do? I am creating a .csv file from our Payables system with all
> > >of the information needed. It is formatting it for the ARP Standard that is
> > >giving me fits.
> > >
> > >
> >
> > I don't know what that format is.
> >
> > If you were in the US, then possibly this format is merely dollars and cents,
> > without the decimal.
> >
> > If that is the case your original numbers should have two decimal precision.
> >
> > Just multiply the numbers by 100.
> >
> > If some of these values are the result of computations, ROUND them to two
> > decimal first.
> >
> > e.g. =100*ROUND(A1,2)
> >
> > How to do this most easily depends on more information than you have posted.
> >
> >
> > --ron
> >