Re: [libreoffice-users] Re: How to enter Dates in a format to allow the counting of days lapsed between a from a date cell and a to a date' cell

2012-01-24 Thread Tom Davies
Hi :) I think for data-entry it is best to enter the date as 01/24/2012 and then have the cells formatted to display that in whichever way you want.  It feels a bit weird to enter a date as numbers and then see it displayed as wordnumbers but doing it that way makes everything else fall into

Re: [libreoffice-users] Re: How to enter Dates in a format to allow the counting of days lapsed between a from a date cell and a to a date' cell

2012-01-24 Thread Tom Davies
Hi :) Thanks Andreas.  It works!  There are all sorts of neat tricks but that is the fastest way to enter dates.  I hope that helps our op. Thanks and regards from Tom :) --- On Tue, 24/1/12, Andreas Säger ville...@t-online.de wrote: From: Andreas Säger ville...@t-online.de Subject:

Re: [libreoffice-users] Re: How to enter Dates in a format to allow the counting of days lapsed between a from a date cell and a to a date' cell

2012-01-20 Thread jorge
Hi: You only have to input like this example: in cell A1 : 10/12/2011 in cell B1 : 12/12/2011 in cell C1 : +B1-A1 --- Result = 2 in cell C1 Regards, Jorge Rodríguez ___ El jue, 19-01-2012 a las 08:25 -0800, Tom escribió: Hi :) I think you are not

Re: [libreoffice-users] Re: How to enter Dates in a format to allow the counting of days lapsed between a from a date cell and a to a date' cell

2012-01-19 Thread Dan Lewis
Here is how I do it. I use Column A for the beginning date,Column B for the ending date, and Row 1 for the column headings. I enter the first beginning date in cell A2 and first ending date in cell B2. I continue adding the beginning and ending dates down these two columns. In cell

Re: Re: [libreoffice-users] Re: How to enter Dates in a format to allow the counting of days lapsed

2012-01-19 Thread SARoets
Unsubscribe me please! The unsubscribe procedure does not work! -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette