Column formatting: Click on the image or this text to see how this task is carried out in an animated sequence of images. Each column should have its own type to be displayed correctly. In Excel and LibreOfficeCalc, dates are stored as correlative numbers starting in January 1,1900 (number 1). If you don’t select date as data type, you will see the correlative number instead of the date. 13