I have a spreadsheet that was correctly sorted by date. I recently pasted additional data into it and re-sorted. The new data is now all together, placed where the first entry belongs. the rest of the new entries stay with it, but won't sort among the whole sheet.
All dates are in "short date form"
Sort this kind of data all the time, never had a problem.
check the newly pasted dates if they are "really" dates maybe they are text when pasted... you can to it with text-to-column - delimeted- date-then choose the format.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
efaaonson 
Register To Reply
Bookmarks