Formatting Birthdates Issue

I have been having some trouble with getting some birthdates formatted the way I want. They are part of a report imported from my company's system in a .txt file that I converted to .xlsx. When I wen...