Dates showing as #################### in Excel Export

[abweiss4]

Has anyone encountered an issue (and how to resolve) where open/close/updated dates from cases are showing as #################### in an Excel export rather than as the date and time? 

[Brian Lancaster]

No, but have your tried formatting the cell as a date to see if that fixes it. Note sure why excel would do that but it seems more like an excel issue then ServiceNow.

[AndersBGS]

Hi @abweiss4 ,

no I haven’t encountered that issue, but as @Brian Lancaster suggested which I also would recommend is to format the cell / row according to the format that you would like.

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Dr Atul G- LNG · Accepted solution]

Hi @abweiss4 

It depends on your excel cell length or I will say format.

Just expand the cell n you can see the date. 

In SN we store date n time together,  so it did not fit when we Export and show # 

[abweiss4]

Thank you for the suggestion! Because I was immediately copying the data into a Google Shreadsheet, I didn't catch that the cell length needed to be enlarged first in Excel. Strange that the value wasn't copied over from Excel to Google Sheets correctly.