Hi,
Is there a simple CSV editor or if I can do this in Excel that will be great too; so I can edit and save my CSV file without the view of my data being changed?
I have a CSV file that if I open in Excel; my UPC column starts showing some UPC numbers in the "E+12" format. I then change the "format" of that column to "number" and it shows the UPCs properly at this point, but UPCs that begin with "0" are no longer being shown properly.
I then tried to change the *.csv file to *.txt so I then could use the "Text Import Wizard". Then during the import I change the UPC column to "text" which imports the UPC numbers properly. However, this then causes another issue with my file where it causes columns not to line up properly with the rest of the data, and then I can't even edit the column I need to because the data doesn't line up properly when I do it this way.
Thank you,
olimits7
Is there a simple CSV editor or if I can do this in Excel that will be great too; so I can edit and save my CSV file without the view of my data being changed?
I have a CSV file that if I open in Excel; my UPC column starts showing some UPC numbers in the "E+12" format. I then change the "format" of that column to "number" and it shows the UPCs properly at this point, but UPCs that begin with "0" are no longer being shown properly.
I then tried to change the *.csv file to *.txt so I then could use the "Text Import Wizard". Then during the import I change the UPC column to "text" which imports the UPC numbers properly. However, this then causes another issue with my file where it causes columns not to line up properly with the rest of the data, and then I can't even edit the column I need to because the data doesn't line up properly when I do it this way.
Thank you,
olimits7
