Text issue on export

S

Schwimms

I have a field in access that does calcuations. When I export data along with
this field into excel the exported data is set as text, I need it to be a
value, how can I correct this in access before it hits excel?
 
M

Maurice

That could mean that the calculations you do are written in a text field. How
do you export to Excel? If it via a query you could try placing:
Val([calculation]) in your queryfield, where calculation is the field with
the calculations in it. If you store it in a table (which you shouldn't with
calculations) you should set the datatype to numeric or double...
 
Top