[libreoffice-users] Calc cell formats

2015-10-02 Thread Thomas Blasejewicz
Good evening I do have (naturally) a number of spread sheets. One is a list of my patients. It includes columns with name, sex, age, date of birth etc. I did create a page style, where I tried to set "numbers" to standard (because there are NO decimals!) and "date" to "1999/02/10". (the file

Re: [libreoffice-users] Calc cell formats

2015-10-02 Thread Brian Barker
At 19:38 02/10/2015 +0900, Thomas Blasejewicz wrote: I do have (naturally) a number of spread sheets. I did create a page style, where I tried to set "numbers" to standard (because there are NO decimals!) and "date" to "1999/02/10". o Spreadsheet page styles do not have cell formatting, so

Re: [libreoffice-users] Calc cell formats

2015-10-02 Thread Thomas
On 2015/10/02 20:12, Michael D. Setzer II wrote: I am thinking the cell is formated to a date format. That number 0 is referenced to 1899-12-30, so when changed to dates 0 to 33 show these numbers. Interestingly, excel uses a simpler date, but last time I checked it didn't work with negative