Thanks again to everyone for your help. I have reached out to the tech team here and they advised that there is another table that has the loan numbers already formatted so I can use that in my join! We were not aware of this as the tables we are working with are new to our team.