I
ian borg
how can i sort the list in format dd/mm/yyyy to keep the ones born before
1946 only?
1946 only?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
How about selecting that column and doing
Data|Filter|Autofilter.
You can filter to show the dates greater than December 31, 1945.
=====
Or you can sort by those dates and then delete the ones you don't want. There's
nothing special about sorting by dates--excel treats them as numbers. And the
format is just that--a format. It doesn't change the underlying value (or
date).
Data|Filter|Autofilter.
You can filter to show the dates greater than December 31, 1945.
=====
Or you can sort by those dates and then delete the ones you don't want. There's
nothing special about sorting by dates--excel treats them as numbers. And the
format is just that--a format. It doesn't change the underlying value (or
date).
B
Bill Sharpe
If you want to see the dates before 1946 the filter should show theDave said:How about selecting that column and doing
Data|Filter|Autofilter.
You can filter to show the dates greater than December 31, 1945.
=====
Or you can sort by those dates and then delete the ones you don't want. There's
nothing special about sorting by dates--excel treats them as numbers. And the
format is just that--a format. It doesn't change the underlying value (or
date).
dates earlier (or less than) 1/1/1946.
Bill
D
Dave Peterson
Thanks for the correction.
Bill said:If you want to see the dates before 1946 the filter should show the
dates earlier (or less than) 1/1/1946.
Bill