Z
ZenMasta
Hi, I have a tab delimited file that has products that I import into design
software and I am having a problem opening it in excel because the product
codes sometimes lead with zeroes. How can I open the file without getting
rid of the zeroes? I can open the file with notepad and see all the product
codes normally, just not in excel.
Currently I'm having to open the text file in note pad, copy everything.
paste into excel. Delete the data format the one column as text, and then
paste again.
Is there an easier way?
Thanks
software and I am having a problem opening it in excel because the product
codes sometimes lead with zeroes. How can I open the file without getting
rid of the zeroes? I can open the file with notepad and see all the product
codes normally, just not in excel.
Currently I'm having to open the text file in note pad, copy everything.
paste into excel. Delete the data format the one column as text, and then
paste again.
Is there an easier way?
Thanks