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."
