Exporting Reports to Excel: Date Formatting
Userlevel 7
+10
When exporting a report that has dates in it to Excel, Excel doesn't recognize that they are dates, and you have to manually change them to dates each time in order to do more analysis. Could this be corrected?
Hey Heather, Thanks for this request. I will look into a way if we can assign a datatype to a column in Excel while exporting. I will reply once the team investigates and affirms it can be done, and will then add to the roadmap.
I echo this request! When all else fails (including DATEVALUE), I use the text to columns shortcut.
Select the column of dates, then Data > Text to columns > Fixed > finish
Select the column of dates, then Data > Text to columns > Fixed > finish
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.