On Mon, 18 Apr 2005 11:37:03 -0700, 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.

Since you are exporting it as a CSV file with a fixed (12) number of spaces in
the column, justification should be irrelevant.

To convert your numbers:

=TEXT(ROUND(A1*100,2),"000000000000")

Then copy/paste special values back over the original numbers.


--ron