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 numbers, but calc does??
0 1899-12-30
1 1899-12-31
2 1900-01-01
3 1900-01-02
31 1900-01-30
32 1900-01-31
33 1900-02-01
Wonderful. And HOW do I tell Calc (AND remember that setting!) that
entering simply "33" in a cell is NOT a date???
As I said: I tried to set numbers to standard and date to "1999/01/10"
format.
The page style I tried to create allows ONLY one OR the other ...
I do not understand, why it has to convert all those simple numbers to
dates.
Thomas
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
