export to CSV - decimal problem

[Cracknell]

I am trying to export to number fields to CSV file samples of the data might be :
-0.13222
and
50.81972

for some reason the export process is not allowing the data to have more than 2 chars after the decimal point and producing;
-0.13
and
50.81

Can anybody help with this problem please.

 

[Fizzio]

If you exporting a table, the default will be 2 dp. Create a query to export and set the number format there and export the query instead.

Sorry - changed my question to an answer

 

[Cracknell]

I am using the Export wizard from the file menu

 

[Fizzio]

See my first post - I was changing it obviously as you posted your second

 

[Cracknell]

Thanks for the tip but I have tried that and I continue to get the same result. I must be doing something else wrong.

 

[Fizzio]

What I meant by set the number format is better described here by thouston

 

[Cracknell]

Thanks but I have also tried that as well, but it has not solved the problem because all the solutions involve treating the data as "text". If, like me, you have a real text field that needs double speech marks to be retained in the output, you have a problem.

Thanks again

 

[Fizzio]

here is the official microsoft document

http://support.microsoft.com/default.aspx?scid=kb;en-us;153364

 

[Cracknell]

Thanks for the assistance, I am really gratefull. I have managed to get around the loss of double quotes by adding double quotes to the "real" text field content before exporting and it has worked a treat.

I cannot imagine why access needs to truncate the decimal places, maybe its just a microsoft thing.

Thanks again.