I work in AP and we have recently begun using Microsoft Dynamics. When I import my invoice overview into Excel I can’t seem to get the date to reformat from m/d/yyyy to mm/dd/yy. the import brings it in formatted general and after I try to reformat it says its date formatted, but not in the format I specified.
Any suggestions as to what the problem is?