MacMost Q&A Forum • View All Forum QuestionsAsk a Question

How Do I Sort Numbers File By Date If File Was SAVED From CSV Date Format?

I’m trying to sort a Numbers (11.2) file by a column of dates if the file was SAVED from a .CSV to a .NUMBERS file?

The problem is the Numbers Dates won’t sort because of the old .CSV FORMAT. I CAN sort them if I add a space to the end of each .Numbers Date, however there are HUNDREDS of different dates to contend with. Is there an easier way or are we just stuck with this solution. I have many .NUMBERS files with this same sort problem.

Although the .CSV dates LOOK EXACTLY like the .NUMBERS dates (04/2002) they WON’T sort without a space after it (04/2002 ). <--like this. For example, I'm trying to sort MANY US Savings Bonds by Maturity Dates so I can keep track of when to redeem them at Maturity date. The .CSV format saved to .Numbers won't sort. ----- Elaine

Comments: 2 Responses to “How Do I Sort Numbers File By Date If File Was SAVED From CSV Date Format?”

    5 months ago

    It sounds like the dates are being treated like text instead of values. Is that correct?
    Select all of the dates (double-click on the column heading).
    Change the format from Automatic to Date.
    This should convert them all to dates.

    Elaine
    4 months ago

    Thank you Gary. You're faster than a speeding bullet with solutions. :)

Leave a New Comment Related to "How Do I Sort Numbers File By Date If File Was SAVED From CSV Date Format?"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)