Excel split problem

%3CLINGO-SUB%20id%3D%22lingo-sub-2340752%22%20slang%3D%22en-US%22%3EExcel%20split%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2340752%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20really%20strange%20problem%20with%20Excel%20split%20and%20I%20don't%20know%20how%20to%20fix%20it%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Unbenannt.PNG%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F279446i913CEAE2E2A40EAD%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Unbenannt.PNG%22%20alt%3D%22Unbenannt.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3BI%20will%20attach%20the%20file.%3C%2FP%3E%3CP%3EBasically%20the%20problem%20is%20that%20when%20I%20want%20to%20separate%20the%20columns%20according%20to%20comma%20I%20go%20to%20DATA%20menu%20and%20use%20text%20to%20column.%20But%20when%20the%20Excel%20want%20to%20change%20the%20last%20column(product%20cost)it%20puts%20date%20instead%20of%20the%20costs%20in%20the%20file!!%3C%2FP%3E%3CP%3EIts%20really%20strange%20can%20anyone%20please%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a really strange problem with Excel split and I don't know how to fix it

Unbenannt.PNG

 I will attach the file.

Basically the problem is that when I want to separate the columns according to comma I go to DATA menu and use text to column. But when the Excel want to change the last column(product cost)it puts date instead of the costs in the file!!

Its really strange can anyone please help.

 

Thank you very much

0 Replies