How do I stop Numbers from changing my data into duration
Is there a function or a setting to stop numbers from changing information automatically? This has never helped me at all, it's always a hurdle, no matter what I am trying to do.
I have a script that has an offset of 10 seconds, I am trying to change the value of every number in a column by -10 seconds. Now the formatting of times codes in videos is 00:00:00:00.
So this is my formula, there is probably an easier way, but I have no numbers or excel experience. I just do movies.
It kills a digit on those first numbers and that makes this whole table useless.
And no matter how often I try to change duration to text, it doesn't change a thing. if I click on another column and back to it, it changes it, it says it's still a duration.
Is there no global way to never have numbers automatically set the column and just keep it as text or something general that doesn't auto format?
MacBook Pro 15″, macOS 12.4
