Addressing Odd Behaviour in Histogram Bin Counting for Experimental Data

[Hypercubes]

I am making a histogram for some experimental data in OpenOffice Calc (Excel equivalent). However, when I have it count frequency for a certain number, it displays odd behaviour.

For example:

Data:
1
499500
1000
375250
1000

Bins:
0
50000
100000
150000
200000

The problem is that it counts the 1 in the data in the 50000 bin instead of the 0 bin, which seems pretty ridiculous. If I set the 0 bin to 5, for example, it is grouped under that. My question is, is this statistically correct behaviour? If not, how should I fix this? Start the bin at 1, perhaps?

Thanks in advance.

 

[Hypercubes]

Never mind, I found what the problem was.

Apparently the frequency function searches for frequency from a bin down to the last one. For example:

Bins
0
5000
10000

The corresponding ranges are:
0-0
0-5000
5001-10000