Importing without excel calculating

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
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
I think this may be what you're thinking of:

go to Tools|Options|Calculation tab and change the setting to manual.

Hope this helps,

_________________<font color="#3399FF" size="3">Kristy</font>  
cat3.gif
<marquee scroll="left" loop="0"><img src=http://www.smilies.nl/dieren/dogrun.gif></marquee>
This message was edited by Von Pookie on 2002-08-26 11:37
 
Upvote 0
Not very easily. Most of it has to be done manually based on search criteria, then the file modified by hand.

IT is not an absurd request, but there are about 2000+ entries, and time is a bit of the essence.

TIA,
Russell
 
Upvote 0
Tools|Options|Calculation

I tried this, it didn't seem to make any difference. It also seemed to not really change the settings permanently, kind of more on a spreadsheet by spread sheet basis. Maybe I didn't do something properly. I'll give it a whirl again...

Russell
 
Upvote 0
On 2002-08-26 11:37, Von Pookie wrote:
I think this may be what you're thinking of:

go to Tools|Options|Calculation tab and change the setting to manual.

Hope this helps,

_________________<font color="#3399FF" size="3">Kristy</font>  
cat3.gif
<marquee scroll="left" loop="0"><img src=http://www.smilies.nl/dieren/dogrun.gif></marquee>
This message was edited by Von Pookie on 2002-08-26 11:37

This really isn't a "calculation" problem. Excel is interpeting the values as they are loaded into a worksheet cell.
 
Upvote 0
On 2002-08-26 11:38, MaximumGravity wrote:
Not very easily. Most of it has to be done manually based on search criteria, then the file modified by hand.

IT is not an absurd request, but there are about 2000+ entries, and time is a bit of the essence.

TIA,
Russell

Will Q&A export a .txt file?
 
Upvote 0
Will Q&A export a .txt file?

hmmmm...not in the tradtional sense. Available export options are *.DIF; Standard ASCII; Fixed ASCII; dBase II-iV; Paradox 2.0/3.x

I will have to experiment with the ASCII formats and see if they are CSV format or not. I tried the dbase formats, and they posed their own series of problems.
 
Upvote 0
I was able to export as standard ASCII, it did give me a choice of delimiters. Then when I imported to excel, I set all columns to text. This seems to have resolved my issues.

Is there any thoughts you had regarding this procedure???

Thanks to all for your help
 
Upvote 0

Forum statistics

Threads
1,213,539
Messages
6,114,221
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top