They are not strings but datevalues - recognized as such by OOo Calc. A Datevalue can be incremented as you have shown without problems. A string cannot be incremented. A string has a numerical value of 0
On 12/2/05, Dennis J. Tuchler <[EMAIL PROTECTED]> wrote: > I have a list of dates, the first one is typed in as a string (1-16-06), > the next bunch are typed in as formulas (=B6+7). I want to convert the > list to strings (so the first string converted would be 1-23-06). I > tried various selections on the "paste special" menu, to no avail. I > know it can be done; I did it under the previous version of > OpenOffice.org but I forgot how to do it. > > -- > Best regards, > > dj tuchler > > Dennis J. Tuchler > University City, Missouri 63130 > USA > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- My OpenOffice Calc Website http://www.openofficetips.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
