AVERAGE function
 

I typed the formula =AVERAGE(P8:P107) and the program returned a hypen -
where the result was supposed to go. Yet when I clicked on the fx formula
bar, the poput window came up and showed the correct result. Why doesn't it
show up on my spreadsheet?

AVERAGE function
 

Try widening the column, and also reformatting the cell to general
formatting


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=555305