By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,400 Members | 981 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,400 IT Pros & Developers. It's quick & easy.

help with query

P: 6
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,
Sep 6 '07 #1
Share this Question
Share on Google+
3 Replies


puppydogbuddy
Expert 100+
P: 1,923
Please post the query you have. Thanks.
Sep 6 '07 #2

P: 47
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.
Sep 6 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
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.
Sep 8 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.