P
Patrick Gomes
We have just started using Office 2003 and I have encountered a problem with
data being exported to Excel from an Access 2003 generated report. This
problem seems to be restricted to only a few codes.Below are the values in
question.
00A shows up as 0.04166667 in Excel
03A shows up as 0.125
05A shows up as 0.208333333
00P shows up as 0.5
00A shows up as 0
Before you say it, the column in Excel has not been formatted as numeric or
such like. This problem did not exist in Access 2000. I created a little
table with these values, and then generated a report in Access 2003. I then
took the option to export the report to Excel and voila.
Has anyone come across this and is there a solution?
data being exported to Excel from an Access 2003 generated report. This
problem seems to be restricted to only a few codes.Below are the values in
question.
00A shows up as 0.04166667 in Excel
03A shows up as 0.125
05A shows up as 0.208333333
00P shows up as 0.5
00A shows up as 0
Before you say it, the column in Excel has not been formatted as numeric or
such like. This problem did not exist in Access 2000. I created a little
table with these values, and then generated a report in Access 2003. I then
took the option to export the report to Excel and voila.
Has anyone come across this and is there a solution?