Re: [users] calc -- Date Sort]
Victor Chapman wrote: I have imported a table of health care benefits received into calc. One of the columns is headed Service Date. Originally the dates were text. They are all in the form DD MMM ( e.g.10 FEB 2005). I applied a user defined format to this column so that calc would recognize the data as dates and not text. This does not seemed to have worked. When I do the sort, it only sorts on DD and ignores the rest. So where do I go from here. TIA - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] If you've just formatted the cells as Date using Format cells that wont work as you'll need to convert the values to an actual DATE number. I've just tried what I think you've done and all it does is sort them by Day not month or anything. Here is the solution... Next to Service Date insert a new column In that Column insert the following... =DATEVALUE([PLACE WITH SERVICE DATE]) replace [PLACE WITH SERVICE DATE] with the row column the service date is in... e.g. if your service date is in A1 enter =DATEVALUE(A1) This will show a weird number - don't worry about that, that is the number of days passed since a certain date (I think it's some date in the 60's!) - but that's how all spreadsheets deal with dates.. Now format that new cell with DATEVALUE in it as a DATE format, you can format it any way DD/MM/YY etc. It will now turn that weird number into the actual date e.g. 10/02/05. If you want to do this for an entire column of dates select the cell you just put DATEVALUE into and move your mouse to the bottom right hand corner of the cell so it turns into a + sign, click and drag down to cover all the way down to the bottom of the data. Regards Darren - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] calc -- Date Sort
Victor Chapman wrote: I have imported a table of health care benefits received into calc. One of the columns is headed Service Date. Originally the dates were text. They are all in the form DD MMM ( e.g.10 FEB 2005). I applied a user defined format to this column so that calc would recognize the data as dates and not text. This does not seemed to have worked. When I do the sort, it only sorts on DD and ignores the rest. So where do I go from here. TIA - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] If you've just formatted the cells as Date using Format cells that wont work as you'll need to convert the values to an actual DATE number. I've just tried what I think you've done and all it does is sort them by Day not month or anything. Here is the solution... Next to Service Date insert a new column In that Column insert the following... =DATEVALUE([PLACE WITH SERVICE DATE]) replace [PLACE WITH SERVICE DATE] with the row column the service date is in... e.g. if your service date is in A1 enter =DATEVALUE(A1) This will show a weird number - don't worry about that, that is the number of days passed since a certain date (I think it's some date in the 60's!) - but that's how all spreadsheets deal with dates.. Now format that new cell with DATEVALUE in it as a DATE format, you can format it any way DD/MM/YY etc. It will now turn that weird number into the actual date e.g. 10/02/05. If you want to do this for an entire column of dates select the cell you just put DATEVALUE into and move your mouse to the bottom right hand corner of the cell so it turns into a + sign, click and drag down to cover all the way down to the bottom of the data. Regards Darren/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] calc -- Date Sort
On Wed, 2006-02-08 at 16:46 -0500, Victor Chapman wrote: I have imported a table of health care benefits received into calc. One of the columns is headed Service Date. Originally the dates were text. They are all in the form DD MMM ( e.g.10 FEB 2005). I applied a user defined format to this column so that calc would recognize the data as dates and not text. This does not seemed to have worked. When I do the sort, it only sorts on DD and ignores the rest. So where do I go from here. Which version of OOo are you using and what OS? I ask because I cannot reproduce your problem. -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] calc -- Date Sort
I have imported a table of health care benefits received into calc. One of the columns is headed Service Date. Originally the dates were text. They are all in the form DD MMM ( e.g.10 FEB 2005). I applied a user defined format to this column so that calc would recognize the data as dates and not text. This does not seemed to have worked. When I do the sort, it only sorts on DD and ignores the rest. So where do I go from here. TIA - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
