I run a report and then export it into excell. In the report all the bin #'s are correct, but in excell a protion of them are shown as dates rather than
00-00-00. Why do only some do this? The items in question were built at various times. SandyIt's being interpreted as a date by MS Excel due to the format of the bin location field. See my reply to your other post.
Tom
What I want to know is why in a database, it formats this entry both numerical and as a date? How is that possible? And what can I do to correct it or work around it? I tried formatting the column in the excell workbook before importing the report, but that didn't work. I tries deleting the field in the item and closing the database, and then reopening and re-entering the data. None of these work. sandy
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.