I've entered the following formula to find the largest value in a list:

MAX(C3:C3000)

So far, there are values in C3 to C35 - the formula is allowing for expansion. The only result I can get is zero. Any suggestions?

Jonathan