query output to excel

[mikeba1]

I have a query that exports to excel, where one of the fields is a currency rate, I have specified the field properties
as format 'fixed' with 4 decimal places.
Fine when you just run the query without exporting it.
When exporting only shows 2 dp?



Any ideas.

 

[PHV]

Did you try to change the NumberFormat property of the excel column after export ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[mikeba1]

Yes, and there were 4 dp.
Why does it not display them?

 

[PHV]

Because the default (General) format of excel is to show 2 dp, I guess.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[mikeba1]

However if I change the format to general with 4 dp it seems to work !!