If you export it with the Save Formatted option, it keeps the decimals;
however, it adds a bunch other junk like so:
---------------------------------------

---------------------------------------
Not acceptable I bet. Here's another trick.

1. Create a query based on the table in question.
2. Put the CStr function around the number field like so to convert it from
a number to a string:

 TheNumber: CStr([NumberField])

Problem: The CStr function upchucks on null values. You need to deal with it
if there are any nulls in that column. Something like a 0 would work.

3. Export this query instead of the table.

4. When going through the Export Text wizard, choose {none} for the text
qualifier.

Hi,
Yes this is what happens when you export from a table as .txt files
Export from a query with a calculated field.
Create a query from your table including all the fields you want to export.
Create a calculated field.
In a new column in the query in design view type this:
       B: IIf(Len([YourNumberField])>0,CStr([YourNumberField]),"")
Replace YourNumberField with your field's name
--B is the new name for this calculated field ( you can give it a different
name)
Now delete the column with the number field (it's not needed as you are
going to export the value from the calculated field instead)
Export the query instead of the table.

The above converts the number to a text string which saves the correct
number of decimal places for each number

Jeanette Cunningham