I am having a problem copying from the clipboard into Sheets on Android.
I have an app that can place some data on the clipboard for further analysis, it is in the form of text lines with delimited fields per line. When pasted into Sheets it populates the rows/columns as one would expect.
Except.
One of the fields is a lap time in the form h:mm:ss.nn, nn being the hundredths of a second part of the seconds, eg 0:00:22.26 being a lap time of 22.26 seconds.
However, when pasted into Sheets, what turns up in the cell is 0:00:22, the hundredths just goes missing. So, tried putting it in "quotes", ie saying please just treat this as text. No different.
It seems that Sheets is thinking, well, this is a time, probably part of a date/time. The times part doesn't need fractions of a second so I'm going to chuck them away. Except I do want them.
I can find no way of making Sheets relent and paste in what I am asking. Am I missing something obvious here?
The underlying data is still there. It is just visually showing h:mm:ss because of the format. Change format to h:mm:ss.sss. Or on mobile,
=TEXT(A1,"hh:mm:ss.sss")
Where A1 has the pasted 0:00:22