help with query

[Aprile]

Hi, everyone. I hope you can help me out with this.

I have this query that I export to an Excel worksheet. Everything works fine except 3 columns' format is not right.

In the query they look like this:
Column1 Colum2 Column3
$56.42 $876.45 $3,843.77

when I click on the number $56.42 it shows 56.42871, $876.45 shows $876.454 and $3,843.77 shows $3,843.7744

I went to properties and changed format to Currency and Decimal Places to 2 but the format is still not right. When I export the query, the columns look fine but not the formula bar. When I use the worksheet to merge, the numbers are formatted wrong.

Thanks in advance,

[puppydogbuddy]

Please post the query you have. Thanks.

[barry07]

I don't know why you are concerned about what appears in the formula bar - surely what's in the column body is what matters to the user and if that's formatted correctly there should be no problem.

What you may not be aware of (I think it's an undocumented feature :-)) is that if you format the columns in your destination spreadsheet and save it subsequent exports of the same query to the same spreadsheet - even with different values - will retain that formatting.

Hope this helps.

[MMcCarthy]

Hi, everyone. I hope you can help me out with this.

I have this query that I export to an Excel worksheet. Everything works fine except 3 columns' format is not right.

In the query they look like this:
Column1 Colum2 Column3
$56.42 $876.45 $3,843.77

when I click on the number $56.42 it shows 56.42871, $876.45 shows $876.454 and $3,843.77 shows $3,843.7744

I went to properties and changed format to Currency and Decimal Places to 2 but the format is still not right. When I export the query, the columns look fine but not the formula bar. When I use the worksheet to merge, the numbers are formatted wrong.

Thanks in advance,

Open the query in design view. Click into the relevant columns and open properties. This should allow you to set the decimal places to two. Does this help?

Also, check how these fields are formatted in the tables. Do they all have the same currancy format with the same properties.