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
It'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
Have something to add? Share your thoughts — no account required.
Ask the community — no account required