Hi,
I have a simple report, laid out in 4 columns. One of the columns is an ingredient concentration. The concentration can be a single value or a range, for example 1-5. When I have the report open and click the 'Analyze with Excel' button, the report opens up in Excel, and everything comes out okay, except where certain ranges are entered. Any range that has one value with a number less than 12 and the other value less than 31 gets converted to a date. So for the entry that in Access that is entered as 1-5, Excel converts this to a date and shows Jan-5, or the date code of 39452. The field in Access is defined as Text. Is there a way to get Excel to treat this as text and not convert it to a date when coming across from Access?
Thanks!
I have a simple report, laid out in 4 columns. One of the columns is an ingredient concentration. The concentration can be a single value or a range, for example 1-5. When I have the report open and click the 'Analyze with Excel' button, the report opens up in Excel, and everything comes out okay, except where certain ranges are entered. Any range that has one value with a number less than 12 and the other value less than 31 gets converted to a date. So for the entry that in Access that is entered as 1-5, Excel converts this to a date and shows Jan-5, or the date code of 39452. The field in Access is defined as Text. Is there a way to get Excel to treat this as text and not convert it to a date when coming across from Access?
Thanks!
