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

abweiss4
Tera Contributor

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? 

1 ACCEPTED SOLUTION

Dr Atul - LNG
Tera Patron

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 # 

View solution in original post

5 REPLIES 5

brianlan25
Kilo Patron

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
Tera Patron

Hi @abweiss4 ,

 

no I haven’t encountered that issue, but as @brianlan25 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 - LNG
Tera Patron

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
Tera Contributor

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.