Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
BarbCline
Contributor III
Contributor III

Send to Excel date format inconsistency

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?

1 Reply
BarbCline
Contributor III
Contributor III
Author

Assuming this is WAD and will change my date format to force the text formatting when data is sent to excel. 

text(MonthName(Date))