Average Function

  • Thread starter Thread starter angy345
  • Start date Start date
A

angy345

Hi ! does anyone know why when i use the AVERAGE Function on an excel
column that contains text,blanks and numbers i get something like
1.28102E+49 as answer.

Help would be very much appreciated..thanks in advance.

Angel
 
Angel,

We would have to see your entire column of data to better understand what
AVERAGE is doing, and why the answer is not what you expect.

Regards,
Kevin
 
The cell is in Scientific format.
Right click the cell, pick Format Cells..., pick the
Number tab, pick Number.
 
Back
Top