Exported data changes to 2 decimal places from none.

[monplankton]

Hi, Wander if any one has come across this before. I'm exporting a query that has currency values in with no decimal places but when it's viewed in excel it has 2 decimal places! I've changed the properties in the query to none, anyone know how to stop this from happening? I'm using 2003.

 

[Galaxiom]

Excel sees it is currency and uses its default currency format, two decimal places.

Change the format on the column in Excel.