If I understand correctly, the data is coming into Excel from your data source that way, right?
If so, I don't think it's a formatting issue, but it's an issue with the data itself. That being said, I think there is an easy fix. Simply create a second Excel column beside the first to 'fix'...