ClaireGoode
New Member
- Joined
- Jan 6, 2017
- Messages
- 13
Hi
We have recently moved to a new (external) system and in order to load our data we have to send the supplier a CSV file.
We create the data in Excel and then Save As CSV. However when you then close and re-open the CSV file many of our numbers convert to Scientific format (things like customer account numbers, phone numbers, etc) and this is what gets imported into our system.
I have tried so many options and read some many posts about this but so far cannot find a solution. As I've said the only format our system will accept is CSV so we can't use the option of .txt (which I know can alleviate the issue). I have also tried adding an apostrophe before the numbers, and converting the columns to text (using Text to Columns Wizard) and converting the columns to numbers (and removing the decimal places).
I had another issues with Chinese characters but have resolved this by saving CSV from .txt and changing the endcoding to UFT-8 which I had hoped might help with the numbers issue too but it didn't!
I am by no means an Excel expert so want to avoid anything like VBA/script writing to stop this happening. Does anyone have any solutions for a mere mortal to use?!
TIA
Claire.
We have recently moved to a new (external) system and in order to load our data we have to send the supplier a CSV file.
We create the data in Excel and then Save As CSV. However when you then close and re-open the CSV file many of our numbers convert to Scientific format (things like customer account numbers, phone numbers, etc) and this is what gets imported into our system.
I have tried so many options and read some many posts about this but so far cannot find a solution. As I've said the only format our system will accept is CSV so we can't use the option of .txt (which I know can alleviate the issue). I have also tried adding an apostrophe before the numbers, and converting the columns to text (using Text to Columns Wizard) and converting the columns to numbers (and removing the decimal places).
I had another issues with Chinese characters but have resolved this by saving CSV from .txt and changing the endcoding to UFT-8 which I had hoped might help with the numbers issue too but it didn't!
I am by no means an Excel expert so want to avoid anything like VBA/script writing to stop this happening. Does anyone have any solutions for a mere mortal to use?!
TIA
Claire.