Prev: chart a location
Next: Add data from other sheet to the data present in this sheet
From: markd on 29 Jan 2010 01:54
I would like to sort a database by date and transaction type. The problem is
the data sorts by time, even though the field is formatted to show date only,
with the transaction type not sorting within the date because it shows up in
the time order. How do I get rid of the time?
From: Stefi on 29 Jan 2010 02:28
If date/time column is A then you have to use an empty helper column filled
with formula =INT(A2) and sort by it.

--
Regards!
Stefi



„markd” ezt írta:

> I would like to sort a database by date and transaction type. The problem is
> the data sorts by time, even though the field is formatted to show date only,
> with the transaction type not sorting within the date because it shows up in
> the time order. How do I get rid of the time?
 | 
Pages: 1
Prev: chart a location
Next: Add data from other sheet to the data present in this sheet