Export table to fixed width text file

[Lloyd]

I am trying to export a text file to be imported in to excel but whenever I export as fixed width all by number columns get cut to 2 decimal places, does anybody know how to get around this?

Thanks

 

[gemma-the-husky]

obvious things, but...

1. are you using a saved export specification file to generate the output

2. is your underlying table or query formatted with currency/doubles having only 2 dps. Have a look at the query results.

3. Should you definitely have more than 2dps in your results?