Is this possible??

  • Thread starter Thread starter coldasice
  • Start date Start date
C

coldasice

I have a set of numbers like

90-93
70-86
92-72
91-88
90-89
97-79
76-87

How do I average these numbers without divide by 0 error? please help.
Thank
 
Those are not numbers. In spite of the numerals, they are text because of
the included "-".
 
What are you trying to average? Is this supposed to be 7 four digit numbers, or 14 two digit numbers. Your division by zero error is because in Excel you don't have any numbers, these are all text. Thus your denominator sums up to zero

Regards
Mark Graesse
(e-mail address removed)

----- coldasice > wrote: ----

I have a set of numbers lik

90-9
70-8
92-7
91-8
90-8
97-7
76-8

How do I average these numbers without divide by 0 error? please help.
Thank
 
Use Data>Text to columns in the Menu bar to seperate the numbers from the -

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)




Jim said:
Those are not numbers. In spite of the numerals, they are text because of
the included "-".
Click to expand...
 
This is great solution since I can't average the number which include
"-" like Jim memtioned. Thank you very much Ron! Thanks all.
*Use Data>Text to columns in the Menu bar to seperate the number
from the -
Click to expand...
 
Back
Top