Hello. We have a situation where for only one user, a resulting query amount column displays in Excel as if the amount is being multiplied by 100. For example, the correct amount of 3,200.00 displays incorrectly as 320,000.00 The other columns(Text or General formatted) returned from the query display correctly. It is only the amount column that has an issue. There are no formulas behind this amount column. The column is formatted as a Number with two decimal places. We’ve tried some other numeric formats as well. The user having this issue is located in Germany. This same excel file works and displays correctly for all other users. The other users are all located in the United States. One of our initial thoughts was to look at the user’s Excel settings to hopefully find a setting that might need to be set differently in Europe, such as commas versus periods, but we believe that we have checked each of those. The query is a pretty straight forward select on a DB2 table which is called\referenced by an Access db data connection in the Excel spreadsheet. The query returns the correct number of rows to Excel, but again the issue is just the amount column that is displaying incorrectly for one user.
Any other suggestions on what we should check on the Excel side of this would be much appreciated. Thanks!
Bookmarks