Analyze It with MS Office Excel

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

Hello, I have a Access 2003 report, one of the fields on the report display
data like 09-4952 they then use the "Analyze It wtih MS Office Excel"
feature, when this value gets to Excel it looks like 1114966. Is there any
properties I can set to keep the 09-4952

Thanks
 
Don,

I'm not expert on MS-Excel, however it seems Excel is interpreting 09-4952
as a date. The integral value for the date 1st Sep 4952 is 1114966. Would be
worth a try to convert the 09-4952 field to a string (using Str() in your
query) and see if that causes Excel to also see the value as a string.

HTH
Sam
 
Back
Top