Yep tried to format as text the whole sheet but as soon as i import the next page it just changes it back, i am thinking there is a setting i can use to not import the formats but i have tried everything i know.