decimal places

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, when i export from access to text it will only
show 2 decimal places and i need to see all of them. Is
there a way to change this.
Thanks
 
Wow, that is way stupid. But I think I have a work-around

Use this
Format([value],"0.00########"

Or this
Str([value]

WARNING: Both of these solutions will make the column a string, when you export, you will have " around your number (i.e. "1.333333333333333"). But you will have all your decimal places

You can also export to Excel and then save to Text, but who really wants to do that

A Select All,Copy and Paste into Notepad also does the trick

Hope this helps

Jim
 
yep thanks.
-----Original Message-----
Wow, that is way stupid. But I think I have a work- around.

Use this:
Format([value],"0.00########")

Or this:
Str([value])

WARNING: Both of these solutions will make the column a
Click to expand...
string, when you export, you will have " around your
number (i.e. "1.333333333333333"). But you will have all
your decimal places.
 
yep thanks.
-----Original Message-----
Wow, that is way stupid. But I think I have a work- around.

Use this:
Format([value],"0.00########")

Or this:
Str([value])

WARNING: Both of these solutions will make the column a
Click to expand...
string, when you export, you will have " around your
number (i.e. "1.333333333333333"). But you will have all
your decimal places.
 
i have found this to be true as well. knowledge base
article 208408 discusses it but the resolution is that the
value you see in your exported file will be text
(encapsulated by quotations); if you can live with that
fine, but my downstream folks require that they see a
number when there's a number.
 
Back
Top