Dataloader requires CSV Files. When I convert my files to CSV it changes the numbers to "Scientific Notions":
Then they show up in Salesforce as Scientific Notions "4.90001E+11".
The only workaround that i've found is, Format the numbers in Excel to "Custom = 0", then dont open the file again, then insert the data with dataloader.
Is this really the only way to proper way to achieve this? Or is there a better way?
The main reason I ask is because I'm merging 500,000+ rows of data from one Org to another and all of that data will be broken down in roughly 20-30 spread sheets. :\