On 5/10/2010 1:34 PM, James Knott wrote:
JOE Conner wrote:
On 5/10/2010 10:13 AM, Tom Bracken wrote:
How can i sort on the date field in a sheet? Suppose the format is
mm/dd/yyyy. Won't it be sorted on month? Thanks.
Dates are stored as a floating point number. What you see is pure
formatting. The sort sorts on the number. In other words, the
format of your date does not matter at all to the sorting.
Why would a floating point number be used? Wouldn't an integer be
more suitable?
Not at all, because the same number is also be used for date AND time.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
