#DIV/0!

%3CLINGO-SUB%20id%3D%22lingo-sub-2382677%22%20slang%3D%22fr-FR%22%3E%23DIV%2F0!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2382677%22%20slang%3D%22fr-FR%22%3EHello!%3CBR%20%2F%3EI%20need%20help%20about%20a%20division%20by%200.%20I'm%20trying%20to%20do%20some%20averages%20on%20an%20excel%20sheet%20but%20I'm%20lost.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20still%20have%20this%20error%20even%20if%20I%20change%20the%20type%20of%20data%20or%20formula%20I%20want%20to%20use.%3CBR%20%2F%3E%3CBR%20%2F%3ETo%20make%20it%20simple%2C%20I%20need%20to%20make%20an%20average%20about%20a%20column%20that%20is%20very%20loaded%20of%20data%20and%20that%20comes%20from%20an%20automatic%20system%20(CSV%20file%20if%20it%20can%20help%20you).%20I%20made%20a%20supervision%20sheet%20where%20I%20collect%20the%20data%20in%20order%20to%20present%20them%20as%20a%20graph.%20Making%20averages%20before%20didn't%20cause%20me%20any%20problems%20(maybe%20because%20the%20numbers%20don't%20have%20and%20decimal)%20but%20when%20I%20try%20with%20cells%20like%20this%20(3%2C134)%20it%20shows%20me%20the%20error.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20don't%20know%20what%20to%20do%20next.%20I'm%20French%20but%20can%20easily%20speak%20English%20or%20Italian%20for%20help.%20I'm%20available%20when%20you%20want%20and%20maybe%20we%20can%20talk%20on%20another%20platform%20(discord%2C%20emails%2C%20Skype%20WhatsApp....)%20to%20simplify%20the%20exchange.%3CBR%20%2F%3E%3CBR%20%2F%3EHope%20you'll%20bring%20me%20help%2C%20cause%20I'm%20very%20lost%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Thanks%20a%20lot%20%3CBR%20%2F%3E%20Thomas%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2382677%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2382696%22%20slang%3D%22en-US%22%3ERe%3A%20%23DIV%2F0!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2382696%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1062328%22%20target%3D%22_blank%22%3E%40INEEDHELP21%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMost%20probably%20you%20have%20texts%20which%20looks%20like%20numbers.%20Try%20to%20convert%20them%20to%20numbers%2C%20one%20of%20the%20ways%3A%20select%20column%2C%20Data-%26gt%3BText%20to%20Columns%2C%20and%20in%20most%20cases%20Finish%20on%20first%20step%20works.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
Hello!
I need help about a division by 0. I'm trying to do some averages on a excel sheet but I'm lost.

I still have this error even if I change the type of data or formula I want to use.

To make it simple, I need to make an average about of a column that is very loaded of data and that comes from an automatic system (CSV file if it can help you). I made a supervision sheet where I collect the data in order to present them as a graph. Making averages before didn't caused me any problems (maybe because the numbers don't have and decimal) but when I try with cells like this (3.134) it shows me the error.

I don't know what to do next. I'm French but can easily speak English or italian for help. I'm available when you want and maybe we can talk on another platform (discord, mails,Skype WhatsApp....) to simplify the exchange.

Hope you'll bring me help, cause I'm very lost

Thanks a lot
Thomas
1 Reply

@INEEDHELP21 

Most probably you have texts which looks like numbers. Try to convert them to numbers, one of the ways: select column, Data->Text to Columns, and in most cases Finish on first step works.