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.
Joe Conner, Poulsbo, WA USA
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
