Forum Discussion
Excel time formatting
hi I have an excel file which is in one of the columns of that time In this case, I cannot get the average from it, and I have double click on each cell twice to be able to get the average from th...
The #DIV0! means that there are no numbers within the list, only text. You can either recommit the text, as you are doing or by using 'text to columns', or use formulas to force Excel to coerce the text to numbers. Techniques include the function VALUE or TIMEVALUE or preceding the reference by a double unary minus "--".
- thanks a lot
I appreciate the solution you gave me
