I have some data in calc like so:
05:00:27 01:27:02 07:29:57 06:22:01
I select the cells, and right click 'format cells', and choose
Time -> 876613:37:46. When I do this, it adds an apostrophe to the beginning of each cell, so the data ends up like this:
'05:00:27 '01:27:02 '07:29:57 '06:22:01
Why is that? How can I prevent it?