Excel refrech gives a strange date error RRS feed

  • Question

  • Hello

    Export to dynamic worksheet works as expected. However if we do a Refresh from CRM some of the date values are changed from 15-12-2015 to 42353.25 and others are displayed as ######.

    Not sure if it is CRM or Excel that is doing this. Perhaps some format setting? Any suggestions?

    Thank you.    
    Wednesday, December 16, 2015 12:51 PM

All replies

  • Hi Don, this is definitely Excel formatting values for you. 42353.25 is internal representation of 15dec2015 06:00, and ###### means the column is not wide enough to display what's in the cell. Check what format you set for the column that the dates are returned into, and what's your setting for 'Preserve cell formatting' in data range properties.
    Monday, December 21, 2015 8:51 AM
  • Hi Don,

    Juz double click the at the column name where you want to see the date. 

    example : Double click at the highlighted place, when + symbol is seen.

    Regards, Rekha.J

    Monday, December 21, 2015 9:26 AM
  • Its excel, you'll need to update the column to display date in the format you want.

    Regards, Donna

    Monday, December 28, 2015 4:43 PM