Number precision

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

Hi all,

I have a DoCmd.transferspreadsheet in Access
The query I use has three fields that are double, but I open the file in
Excel the precision is lost. So I forced the precision by using:

Format(mydoublefield1, "0.0000") as mydoublefield1

But now when I open the file in Excel, the numbers in the fields become
text with a "'" in front of each number. What did I do wrong?

Thanks for sharing your thoughts/suggestions.

Ben
 
After you transfer your data to excel, did you try formatting the excel
fields with 2 (or more) decimal places?
 
Just thinking out loud here, but doesn't the Format() function return a String?

If I'm remembering that correctly, that may be your issue

--
Jack Leach
www.tristatemachine.com

- "First, get your information. Then, you can distort it at your leisure."
- Mark Twain
 
Back
Top