with my column formated for date I cannot seem to sort it .I enter gas costs
with random dates for a period of a year then when finished enterintg data
I try to sort it in date order and it will not give me a logical sort

Make sure that the column contains dates and is not formatted as date...

To test, change the cell format to number... it should show 39971 if the
date in the cell was 7th June...

"Grant" wrote:

with my column formated for date I cannot seem to sort it .I enter gas costs
with random dates for a period of a year then when finished enterintg data
I try to sort it in date order and it will not give me a logical sort

Perhaps some of your values are text and some are real dates?
=ISTEXT(cellref) and =ISNUMBER(cellref) will tell you.
--
David Biddulph

Grant wrote:
with my column formated for date I cannot seem to sort it .I enter
gas costs with random dates for a period of a year then when
finished enterintg data I try to sort it in date order and it will
not give me a logical sort

So I can enter the data in actual date form ,then change to number form ,
sort , then change back to actual date form?
Thanks for your reply by the way!

"Grant" wrote:

with my column formated for date I cannot seem to sort it .I enter gas costs
with random dates for a period of a year then when finished enterintg data
I try to sort it in date order and it will not give me a logical sort