Wendell,

I would open the import file in notepad to see if the formatting issue is obvious. Excel could be showing values differently than what's in the actual cell.