Median gives zero

[judikz]

I am calculating the median of a column with over 4200 rows. None of the numbers are negative and the max is over 16,000; however, the MEDIAN function is returning zero (no matter how many decimal places I add to see it).

What is causing this and how can I fix it?

Thanks

[Special-K]

MEDIAN just returns the middle number doesn't it?
Therefore negative numbers are irrelevant

Assuming you have 4200 rows
If you sort the data what value is at position A2100 ?
Is it zero?

Prob best post the column in a spreadsheet

[judikz]

Yes, when I sort the middle number is zero, I guess that explains it.

Now I feel like an idiot : )

Thanks!!!!