Re: [libreoffice-users] Calc cell formats

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: users+unsubscribe@global.libreoffice.org
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