Yeah I have seen this same sinereo but i would like to make this seemless without having to give my endusers 20 steps to import one thing i did that i had hoped would solve this was use the excel com object to autoformat those types of columns visuly this solves my problem but when i go to import i still expieriance the same issues