Data CHANGED .... HOW ?
I created an ODS file and dates & time I entered as TEXT (such as: 102515 2:00am) changed to 5-digit #s with 2 colons followed by more numbers (looks like they may have been the time). See row 2, columns B,C,D,F. Col. E is OK. How do I correct this, putting it back to the original entry? Marie Desiderio West Palm Beach, FL 33406 561-967-9848 home 561-319-0438 cell cars 102515.ods Description: application/vnd.oasis.opendocument.spreadsheet - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Data CHANGED .... HOW ?
On 05-Jan-16 06:54, Marie Desiderio wrote: I created an ODS file and dates & time I entered as TEXT (such as: 102515 2:00am) changed to 5-digit #s with 2 colons followed by more numbers (looks like they may have been the time). See row 2, columns B,C,D,F. Col. E is OK. How do I correct this, putting it back to the original entry? Change the cell format to date e.g. DD/MM/ HH:MM:SS Marie Desiderio West Palm Beach, FL 33406 561-967-9848 home 561-319-0438 cell - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Data CHANGED .... HOW ?
You have the cells formatted as time. If you want the entry to be text, you may put a preceeding apostrophe to preserve the data as a text string. Such as QUOTE '03/03/1904 15:11:00 END QUOTE in column C2 for instance. I hope this helps. Blessings, Joe Conner, Poulsbo, WA USA On 01/04/2016 11:54 AM, Marie Desiderio wrote: I created an ODS file and dates & time I entered as TEXT (such as: 102515 2:00am) changed to 5-digit #s with 2 colons followed by more numbers (looks like they may have been the time). See row 2, columns B,C,D,F. Col. E is OK. How do I correct this, putting it back to the original entry? Marie Desiderio West Palm Beach, FL 33406 561-967-9848 home 561-319-0438 cell - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org -- Blessings, Joe Conner Joshua 24:15 "...as for me and my house, we will serve the LORD."