Transfer Text, Export Delimited w/ Number formated to 4 decimals.

  • Thread starter Thread starter luchshel
  • Start date Start date
L

luchshel

Want to export table to delimited text using a macro. The macro uses
Transfer Text, Export Delimited. It works but the export truncates a four
digit decimal field to two digits.

Table Record:
Field 1 (Text): 3011-52020
Field 2 (Decimal, 18,4,4): 1000.5555

Output Record
Field 1: "3011-52020",
Field 2: 1000.55

I need the four decimal places. Assistance would be appreciated.
 
Luchshel,

I am not sure why this is happening. However, here are two ideas to try...

1. Change the data type of this field to Currency, and set its Format as
General Number.
2. Do your export from a query, and use this in the place of Field 2:
Format([Field 2],"#.0000")
 
Back
Top