Is this possible??

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
 
J

Jim

Those are not numbers. In spite of the numerals, they are text because of
the included "-".
 
M

Mark Graesser

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
[email protected]

----- 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
 
R

Ron de Bruin

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...
 
C

coldasice

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...
 
Top