MaximumGravity
New Member
- Joined
- Apr 16, 2002
- Messages
- 29
Hello all,
I remember seeing this posted before, only now that I need it, I can't find the answer.
So pardon the repetition, but.....
I have a *.dif (Data Interchange Format) file that I am importing from Q&A. When I bring it into excel, it corrupts some of the data by trying to claculate certain values.
For example, a stock number of 0E55 translates to 0E+55 then tries to calculate out to 100000.
Example 2, all of my two digit date codes (i.e 00, 01, 02, 03) get appended to drop the first 0, and become a single digit number.
Any and all help appreciated. I believe it is somewhere in the Options menu's, but Mr. Gates cronies were being oh-so-vague when developing this particular section....
TIA
Russell
I remember seeing this posted before, only now that I need it, I can't find the answer.
So pardon the repetition, but.....
I have a *.dif (Data Interchange Format) file that I am importing from Q&A. When I bring it into excel, it corrupts some of the data by trying to claculate certain values.
For example, a stock number of 0E55 translates to 0E+55 then tries to calculate out to 100000.
Example 2, all of my two digit date codes (i.e 00, 01, 02, 03) get appended to drop the first 0, and become a single digit number.
Any and all help appreciated. I believe it is somewhere in the Options menu's, but Mr. Gates cronies were being oh-so-vague when developing this particular section....
TIA
Russell