I am using LibreOffice Version: 6.1.5.2
I cannot find a way to remove autoformat from Calc.
I am trying to enter 00:10:00
as a value and it keeps converting it to 12:10:00 AM
. This is a timecode and I need to build a lot of these.
I have looked online but all I found was a post from 2012 and that is not applicable. I also would really only like to ignore a column and not turn it off completely but for now I will take a full removal of autoformat. I'm sure it has the capability but I cannot find it at all.
I have tried to Clear Direct Formatting but then it converts my value to 0.00694444444444444
... This is pretty frustrating so I am hear asking for help.
Thanks