Big format problem when exporting a query to excel

  • Thread starter Thread starter RobertM
  • Start date Start date
R

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.
 
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
 
Lord Kelvan said:
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
Click to expand...

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,
 
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
Lord Kelvan said:
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
Click to expand...

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,
Click to expand...
 
Back
Top