sorting

[Grant]

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

 

[Sheeloo]

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]

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!