I have two objects with the exact same data. One is a combo chart, the other a straight table. When I “send to excel” each object, the straight table retains its date format (Sep 2011). However, the combo chart date changes to a numeric format (40787).
Aside from formatting the date as text, how do I retain the correct date format with the combo chart? Why does this work properly for one object and not another? Perhaps a bug?