Exporting to Excel/date sort. Bug fix? When I export to Excel and want to sort by date, it doesn't recognize the numbers as a date. The date is not set correctly in Sage to properly sort in Excel. The only way for Excel to recognize as a date is by removing the space in front of the date and then I can right click and format. This is not right! Can this be fixed?
by: Nicole B. | over a year ago | 8 Reports and Inquiries
Comments
You can just select the entire range in Excel and auto replace all blanks with nothing and that will fix the issue