I have a single column of dates in this format:e.g.,

9/25/2006 18:06
9/25/2006 18:32
9/26/2006 13:06
9/28/2006 15:45

I used then something like Value (Left(cell,5) to get a numeric value of
38985 for the date of 9/25/2006

All appears to be good at this stage.

I then used the HIST function to get a distribution cout of the dates, and I
get this weird output:


Bin Frequency
38985 26
38985.16667 0
38985.33333 0
38985.5 0
38985.66667 0
38985.83333 0
More 12

Why is the Bin column still showing snippets of the timestamp..?

thanks in advance