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