I imported a column with dates in my sheet. The are of the form yyyymmdd. Thus 20121023, 20121022 etc .
I want to apply date related functions on this column, but for libre office these fields are just numbers. How can I make libre office recognize them as dates?