Hi All,

I have an excel spreadsheet linked to Access.

I input some information in Access and it appears in the Excel ss.

The problem is that the numbers are formatted as text. This produces an
error because the numbers are in a summed column. In Excel the column is
formatted as number.

Any ideas on how I can force the text to be formatted as number when it
receives new data. The Excel Form is not open when updated by Access.

Any help greatly appreciated,

Jeff