Output format in Excel

  • Thread starter Thread starter Phil Amey
  • Start date Start date
P

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
 
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>

Phil Amey said:
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
Click to expand...
forcing the whole number from Access ?
 
Back
Top