TUG Tip - Sage 300 CRE

TUG Tip -- Sage 300 CRE

Quickly get to date format when exporting inquiries to Excel

When inquiries are exported to Excel, dates are not initially formatted as dates due to leading spaces. To quickly get to date format so you can sort by date, highlight the columns that contain dates that are important to be in date format and use find and replace (Ctrl + H): put one space in the Find what field and don't put anything in the Replace with field. Click Replace All, and your dates are now formatted as dates!