I have a box full of recipets (1 or 2 a day for the last 2 yrs) Now i have to
have them in order by date. I know im going to have to put them in the pc by
hand but is there a sorter that will arange them by date>

Hi Driver,

Provided that your data input includes
a date field, it should be possible to
sort the data with a single click of
Excel's sort icon - unless there is an
element of your question which has
escaped me.



---
Regards.
Norman


"driver" <(E-Mail Removed)> wrote in message
news:68FB370F-04B4-416E-81F5-(E-Mail Removed)...
>I have a box full of recipets (1 or 2 a day for the last 2 yrs) Now i have
>to
> have them in order by date. I know im going to have to put them in the pc
> by
> hand but is there a sorter that will arange them by date>

Hi,
You can enter them in any order you like.
Just make sure the dates for each receipt are in the same column - doesn't
matter which one.
When it's all entered, select all the data. From the DATA menu choose SORT,
and tell XL which column your dates are in, press ok.
Regards - Dave.

"driver" wrote:

> I have a box full of recipets (1 or 2 a day for the last 2 yrs) Now i have to
> have them in order by date. I know im going to have to put them in the pc by
> hand but is there a sorter that will arange them by date>

Open a new workbook.

In A1 enter the word Date.

In A2 start entering the date on each receipt and other info across the row in
separate cells.

Work your way down in any order.

When you get all recipts entered select all columns then Data>Sort>Sort
ascending on the Date column.


Gord Dibben MS Excel MVP

On Sat, 3 May 2008 10:36:01 -0700, driver <(E-Mail Removed)>
wrote:

>I have a box full of recipets (1 or 2 a day for the last 2 yrs) Now i have to
>have them in order by date. I know im going to have to put them in the pc by
>hand but is there a sorter that will arange them by date>

A reminder..........make sure the dates are entered in a format acceptable to
Excel which of course dpends upon the short date setting in Windows Regional and
Language Settings.

i.e. SD settings are mm/dd/yyyy

Don't enter dates as dd/mm/yyyy or tExcel will treat them as text and won't
sort properly.


Gord


On Sat, 03 May 2008 10:50:38 -0700, Gord Dibben <gorddibbATshawDOTca> wrote:

>Open a new workbook.
>
>In A1 enter the word Date.
>
>In A2 start entering the date on each receipt and other info across the row in
>separate cells.
>
>Work your way down in any order.
>
>When you get all recipts entered select all columns then Data>Sort>Sort
>ascending on the Date column.
>
>
>Gord Dibben MS Excel MVP
>
>On Sat, 3 May 2008 10:36:01 -0700, driver <(E-Mail Removed)>
>wrote:
>
>>I have a box full of recipets (1 or 2 a day for the last 2 yrs) Now i have to
>>have them in order by date. I know im going to have to put them in the pc by
>>hand but is there a sorter that will arange them by date>

I like to add this to Gord's reply

>A reminder..........make sure the dates are entered in a format acceptable to
> Excel which of course dpends upon the short date setting in Windows Regional and
> Language Settings.

The ISO date format will always work

yyyy-mm-dd

If you want to read more see
http://www.rondebruin.nl/isodate.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Gord Dibben" <gorddibbATshawDOTca> wrote in message news:(E-Mail Removed)...
>A reminder..........make sure the dates are entered in a format acceptable to
> Excel which of course dpends upon the short date setting in Windows Regional and
> Language Settings.
>
> i.e. SD settings are mm/dd/yyyy
>
> Don't enter dates as dd/mm/yyyy or tExcel will treat them as text and won't
> sort properly.
>
>
> Gord
>
>
> On Sat, 03 May 2008 10:50:38 -0700, Gord Dibben <gorddibbATshawDOTca> wrote:
>
>>Open a new workbook.
>>
>>In A1 enter the word Date.
>>
>>In A2 start entering the date on each receipt and other info across the row in
>>separate cells.
>>
>>Work your way down in any order.
>>
>>When you get all recipts entered select all columns then Data>Sort>Sort
>>ascending on the Date column.
>>
>>
>>Gord Dibben MS Excel MVP
>>
>>On Sat, 3 May 2008 10:36:01 -0700, driver <(E-Mail Removed)>
>>wrote:
>>
>>>I have a box full of recipets (1 or 2 a day for the last 2 yrs) Now i have to
>>>have them in order by date. I know im going to have to put them in the pc by
>>>hand but is there a sorter that will arange them by date>
>