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.