Scientific Notation exporting VBA to .CSV opening in XLS

[ItalianPlatinum]

Hello - i have a VBA that will do a set of commands the end of it will export a sheet that has 1 column with a 9 digit letter/number into CSV. Before exporting the 9 digit presents as it should; but when opening in CSV through XLS it converts some of the data that have an "E" in it to scientific notation. Is there anything i can do prior in my VBA to remove this issue? or do i need to use VBA to reopen the CSV, adjust, and save? would rather the first approach seems after.

 

[Joe4]

Hello - i have a VBA that will do a set of commands the end of it will export a sheet that has 1 column with a 9 digit letter/number into CSV. Before exporting the 9 digit presents as it should; but when opening in CSV through XLS it converts some of the data that have an "E" in it to scientific notation. Is there anything i can do prior in my VBA to remove this issue? or do i need to use VBA to reopen the CSV, adjust, and save? would rather the first approach seems after.

There is a good chance that the VBA code is doing what it should. Where the problem probably lies is in re-opening the CSV file in Excel. You see, when you open a CSV file in Excel, Excel will automatically perform the conversions it thinks should happen on the data.

For this reason, if you truly want to see what a CSV file actually looks like, you should not use Excel to view it (because Excel is performing its own automatic conversions on it).
If you truly want to view the contents of CSV file, view it with a Text Editor, like NotePad, WordPad, or your favorite third party Text Editor.

 

[ItalianPlatinum]

There is a good chance that the VBA code is doing what it should. Where the problem probably lies is in re-opening the CSV file in Excel. You see, when you open a CSV file in Excel, Excel will automatically perform the conversions it thinks should happen on the data.

For this reason, if you truly want to see what a CSV file actually looks like, you should not use Excel to view it (because Excel is performing its own automatic conversions on it).
If you truly want to view the contents of CSV file, view it with a Text Editor, like NotePad, WordPad, or your favorite third party Text Editor.

Ok I use the .csv for an upload to another system - opening as XLS as you say will just change display when I open as notepad I do see the field correct so I will move this as a non issue and dont need to change what I am doing.

 

[Joe4]

Ok I use the .csv for an upload to another system - opening as XLS as you say will just change display when I open as notepad I do see the field correct so I will move this as a non issue and dont need to change what I am doing.

Excellent!

Yes, one of my biggest pet peeves is that they set Excel as the default program to open CSV files. It can cause a lot of confusion, as you have seen. I wish they would use a Text Editor program instead. Usually, that default program is one of the first things I change when I get a new computer.

 

[ItalianPlatinum]

Excellent!

Yes, one of my biggest pet peeves is that they set Excel as the default program to open CSV files. It can cause a lot of confusion, as you have seen. I wish they would use a Text Editor program instead. Usually, that default program is one of the first things I change when I get a new computer.

Thanks for your help and knowledge on this. Very much appreciated

 

[Joe4]

You are most welcome.
Glad I was able to help!