exporting as text cutting off significant digits

  • Thread starter Thread starter Effie
  • Start date Start date
E

Effie

I am exporting a query as delimited text. This query has lots of numbers
with lots of decimal places (for example, 0.02323733). When I am in the
export wizard, all looks fine--the value above reads as an exponent
(2.323733E-02). But when I open it in notepad, or Excel, or the statistics
program I'm trying to export the data to, almost all of the data has been
rounded to only 2 decimal places. I need the exact numbers, not numbers
rounded to only 2 decimal places.

If I export to Excel, I get 8 decimal places. I can then export this as
text and retain all the decimal places. But I really don't want to have to
do two exports, one in Access and one in Excel. I would like to just export
to text in one step. Any idea why its cutting off the data at 2 decimal
places and how to fix it?
 
Export it as text using the format function. Rather than just the field
name, change it to a Calculated field:

FixedNumber: Format([TheNumberField],"0.00000000")

This will cause it to export as text and always have eight decimal digits.
So .5 would show as 0.50000000
 
Effie,
the rounding off is the default export behavior.
A workaround is to use a calculated field for the numbers.
Add a new column to the query.
In the Field row type
Expr1:CStr([TheNumberField])
replace Expr1 with a name for this column
export this column instead of the number column.


Jeanette Cunningham
 
Back
Top