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.


"bj" wrote:

> If if needs to stay a number with the same value, I don't think you can do it.
> If you can change the value Just multiple the number by ten to the number of
> decimal places.
> If it can be text set up a new column and use
> =substitute(a1,".',"")
>
> "LAM" wrote:
>
> > I need to format the number cell so that it will still show the numbers after
> > the decimal, but not show the decimal point at all. It must also display
> > leading zeros, which is not a problem. I just need a way to strip the
> > decimal from the number.