Howdy – I’m playing around with Grist for the first time. My data has some alphanumeric fields that are coded as P#####, so I have P0001 and P0239 for example. Another column has codes like A01, A02, etc.
Grist is importing these as dates in the YYYY-MM-DD format. How can I fix this? I’d prefer not to manipulate the data itself, since these fields show up in many places throughout the data set.
P0007 is reading in as 0007-01-01
A02 is reading in as 2002-01-01
I did look through data types, but I’m confused why these aren’t reading in as Text (which is listed as the default!) instead of dates, which I wouldn’t expect to come up with the alpha characters to begin with.
Edit to add: I imported from both Excel (workbook and csv) and Google Drive.