D
Donna
Ok everyone here is how it works i have tested and proved this theory.
If you import your data and tell it is text it ignores that fact all
together, If you format your worksheet and then delimitate it throws out your
formatting every time. This is true in 2003 & 2007 here is how you get
around this.
Open excel copy and paste your data into a worksheet, delimitate that work
sheet to the format needed. At this point your data is bad. Now click a new
worksheet click the diamond of sheet 2 in the corner and format that sheet as
text. Then paste your data into the sheet.
It will keep the style of delimitation and keep your data true no more
scientific format no more having that number rounded and changed
If you import your data and tell it is text it ignores that fact all
together, If you format your worksheet and then delimitate it throws out your
formatting every time. This is true in 2003 & 2007 here is how you get
around this.
Open excel copy and paste your data into a worksheet, delimitate that work
sheet to the format needed. At this point your data is bad. Now click a new
worksheet click the diamond of sheet 2 in the corner and format that sheet as
text. Then paste your data into the sheet.
It will keep the style of delimitation and keep your data true no more
scientific format no more having that number rounded and changed