i am downloading a file from my checking account in dominican pesos which uses the ddmmyyyy format. when i download the file the dates that have a dmyyyy characteristic are being formated by excel as a known date format. the dates that have ddmmyyyy are being formatted as a general type and excel is not letting me put them into a date format so I can then take the entire row and convert it to english mmddyyyy.
any help would be appreciated. attached is an example file
Bookmarks