Changing Date Format after Exporting to Excel

When you export a SmartList or Report from GiftWorks to Excel, the Date format of the cell is text. To change this you need to open the Excel file and select the date column(s) and then do a Find and Replace. Enter / in the Find What field Enter / in the Replace With field Click on Replace All

This will change the cell format from Text to Date. You can now select the date column(s) and choose to Format the cells. Choose the Date option and the format you want. The dates will now change to that format.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Powered by Zendesk