When sorting, OpenOffice / LibreOffice recognizes the dates and sorts by month/date. The displayed cell content will stay "September 2011" because of the custom cell format using the code MMMM YYYY. Select cell A1, apply sorting using Menu Data -> Sort by column A ("month").Īs result, OpenOffice / LibreOffice transforms the values of column A into dates (for example, instead of September 2011).
In field Search for, enter a single dot, and in field Replace with an ampersand ( &) hit More Options, tick Regular Expression. With the cells still selected, select Menu Edit -> Find & Replace.> Numbers Įnter the following format code in the Format Code field: MMMM YYYY Select the cells holding the month/year values.
You could split the text values into two columns (month and year separately) and sort first for year, then for month (see Solution 2 below).You could transform the values of column A as dates so OpenOffice / LibreOffice can sort them accordingly (see Solution 1 below).
0 kommentar(er)
