I have a tabel in MS Access 2010 that I have set up a macro to export using a storedimportexport. When the export file is create (TXT) the trailing zeros are dropped from the amount. Example 10.00 exports as 10. The table shows it as $10.00. The field is set to currency with two decimal places.
In order to import the txt file to another financial software package it must have the trailing zeros. How can I correct this? Thanks!