Yup, that's what I figured. But how do I set the entire column that way?

"Ardus Petus" wrote:

=DATE(1979,8,31)

HTH
--
AP

"Marcelo" a écrit dans le message de
news: ...
Hi Andrew,

is not necessary to use Year, Day or month function on this formula:
use date=(79,8,31)

hth
regards from Brazil
Marcelo

"Andrew" escreveu:

In the cell which contained the date, 08/31/1979, I inserted the
following
formula:

=DATE(YEAR(79),DAY(31),MONTH(8))

Here is what I got: 01/07/1902




"Andrew" wrote:

Thanks for your reply. However, I'm not sure what you are suggesting I
do.

" wrote:

This formula should fix your problem (where your back-to-front date
is
in cell A1):

=DATE(YEAR(A1),DAY(A1),MONTH(A1))

J.

Andrew wrote:

I saved data from a CVS file to Excel. I have a list of dates
which display
as mm/dd/yyyy. However, when I try to sort the dates, they are
organized by
month first, then day, then year as opposed to year, month, day,
which is how
I would like it to sort the info.

I have another list of dates which is being read by Excel as
dd/mm/yyyy but
in fact, the way it is organized, should be read as mm/dd/yyyy. So
the
digits of 10/03/1962 should stay in the same order and be read as
October 03,
1962. But Excel is reading it as March 10, 1962 because when I
format the
date to m/dd/yy it reverses the 3 and the 10.