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

No issue mate. Excel cell has some default length, you may change that.