Hi,
I wondered if this is common but when I download a report from gainsight that contains a date value its not a recognised date in excel, so I need to perform a convert using the =datevalue formula.
Is this a common issue? or is there an easy way around it?
Best answer by Stuart
A solution I’ve used when looking at timestamps in excel is using the custom format cells option in Excel, then matching how the timestamp appears (or how it should be) with either a) one of the pre-built custom options or b) typing in the correct formatting in the box. Can take a bit of finessing, but if it’s a dataset you work with regularly, you can keep the date format saved somewhere, and just copy it into the box when needed.
+11I’d love to hear if anyone has solved for this. My habit of changing the cell formatting so my spreadsheet app recognizes dates (and also often numbers) after downloading is a strong one.
+3A solution I’ve used when looking at timestamps in excel is using the custom format cells option in Excel, then matching how the timestamp appears (or how it should be) with either a) one of the pre-built custom options or b) typing in the correct formatting in the box. Can take a bit of finessing, but if it’s a dataset you work with regularly, you can keep the date format saved somewhere, and just copy it into the box when needed.
+11I like the approach,
I’m forever wrestling with the need to adjust data formats after exporting data. Any ideas to speed this up are welcome.
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
