How do I place (open) CSV files in Excel for MasterFile?
Whenever you are working with CSV files for MasterFile, they must be placed in Excel from the Excel data tab as text, not double clicked or opened. In the latter case, dates and other values are incorrectly represented in Excel and will affect those values in MasterFile.