Input from Access - formatting problem

J

Jeff

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
 
D

Debra Dalgleish

How are you transferring the data?
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
Click to expand...
 
J

Jeff

Debra said:
How are you transferring the data?
Click to expand...

I have the excel ss linked to the database on a subform, it's not
imported and I'm not using code. I linked to the file and embedded the
linked table in an Access form.

Thanks for the help.

Jeff C
 
D

Debra Dalgleish

It may depend on what was in the table when you linked it. If you post
to an Access newsgroup, and describe the problem, including what version
of Office you're using, someone may be able to help.
 
Top