Number does not retain the format 5.00 becomes 5

[rowdycajun]

I've have a query where the number field is formatted as standard and 2
decimal places. I have also hard coded the field as Format (Field Name,
"0.00"). No matter what I do when I export the query as text tab delimited.
It does not retaining the format so 5.50 is 5.5 and 5.00 becomes 5. I have
deadline to meet and this is driving me crazy.

 

[Jeanette Cunningham]

Hi rowdycajun,
the number format is lost when you export as a txt file.

A way that works for me is to create a calculated field in the query which
converts the number to a text string.
In a new column in the query type NewNbr:CStr([FieldName])
Export the calculated column called NewNbr instead of the number field.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia