Big format problem when exporting a query to excel

[RobertM]

I'm trying to export a query to Excel. Below is an example of the numbers I
want to see:
0.001568257
0.00021853
0.00001812

Here are the values coming up in the excel export
Impact
7.16367843422814E-07
1.01770109708894E-08
8.43835607191398E-10

The project we're using this database for is too fast paced for us to be
able to take the time to update the formatting on the spreadsheet. Any help
is greatly appreciated.

 

[Lord Kelvan]

you need to format the numbers before exporting what you are recieving
in excel are the actual values they are just mathmatically compressed

use something like

format([thefield],"0.00000000")

which will restrict it to 8 decimal places

Regards
Kelvan

 

[RobertM]

you need to format the numbers before exporting what you are recieving
in excel are the actual values they are just mathmatically compressed

use something like

format([thefield],"0.00000000")

which will restrict it to 8 decimal places

Regards
Kelvan

I've been trying to add that SQL without any luck. I've added part of the
query below. The feild in question is called "Impact".

I'm sorry to ask this but can you please show me how to add this to make
this work:

[Difference in USD]/[TotShs] AS Impact,

 

[John Spencer]

Perhaps what you want is
Format([Difference in USD]/[TotShs], "0.00000000") AS Impact,


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

you need to format the numbers before exporting what you are recieving
in excel are the actual values they are just mathmatically compressed

use something like

format([thefield],"0.00000000")

which will restrict it to 8 decimal places

Regards
Kelvan

I've been trying to add that SQL without any luck. I've added part of the
query below. The feild in question is called "Impact".

I'm sorry to ask this but can you please show me how to add this to make
this work:

[Difference in USD]/[TotShs] AS Impact,