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" wrote in message
...
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 DataSortSort
ascending on the Date column.


Gord Dibben MS Excel MVP

On Sat, 3 May 2008 10:36:01 -0700, 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

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 DataSortSort
ascending on the Date column.


Gord Dibben MS Excel MVP

On Sat, 3 May 2008 10:36:01 -0700, 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

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 ...
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 DataSortSort
ascending on the Date column.


Gord Dibben MS Excel MVP

On Sat, 3 May 2008 10:36:01 -0700, 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