Thanks, bj
THat works like a charm!

"bj" wrote:

> It sounds as though multiplying by 100 and using a <format><cells><custom>
> type [0000000000000] should give you the output you need
>
> "LAM" wrote:
>
> > 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
> > > >