sorting

G

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
 
S

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...
 
D

David Biddulph

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

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!
 
Top