Output format in Excel

[Phil Amey]

Hi,

I have a query that sends out in .xls format several columns, one of which is whole numbers.

When I look at this output the whole number column is presented with two decimal places.

I know that the problem is probably with Excel but is there a way of forcing the whole number from Access ?

Cheers - Phil Amey

 

[Ken Snell]

In the query, use a calculated field instead of the real field. In the
calculated field, format the number (using the Format function) to have the
correct number of decimal places.

NewField: Format([FieldName], "0")

Or you can use the CInt function:

NewField: CInt([FieldName])

--
Ken Snell
<MS ACCESS MVP>

Hi,

I have a query that sends out in .xls format several columns, one of which is whole numbers.

When I look at this output the whole number column is presented with two decimal places.

I know that the problem is probably with Excel but is there a way of

forcing the whole number from Access ?