Excel problem

%3CLINGO-SUB%20id%3D%22lingo-sub-3105068%22%20slang%3D%22en-US%22%3EExcel%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3105068%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20download%20a%20csv%20document%20(table)%20from%20investing.com%2C%20and%20when%20i%20open%20it%20in%20excel%20and%20i%20convert%20it%20into%20table%20in%20excel%20and%20i%20start%20calculat%20the%20max%20and%20sum%20and%20....%20the%20result%20alwayse%200%26nbsp%3B%20how%20can%20i%20solve%20this%20problem%20please%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3105068%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3105137%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3105137%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1294763%22%20target%3D%22_blank%22%3E%40ali_abbas730%3C%2FA%3E%26nbsp%3BProbably%20because%20everything%20comes%20across%20as%20text.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

i download a csv document (table) from investing.com, and when i open it in excel and i convert it into table in excel and i start calculat the max and sum and .... the result alwayse 0  how can i solve this problem please ?

1 Reply

@ali_abbas730 Probably because everything comes across as text.