Both the output CSV and my own spreadsheet insist on formatting form figures such as "23-1" as a date, no matter how I format the appropriate column.
Has anyone else come across this, or perhaps have a suggested solution?
Some Guardian-exported horse form formatted as dates.
- MemphisFlash
- Posts: 2161
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
- firlandsfarm
- Posts: 2720
- Joined: Sat May 03, 2014 8:20 am
Not a full answer as I haven't tried exporting form but when I copy form and paste it into a spreadsheet I firstly set the format for the cells where the form will go to "text" and then paste to "match destination format". Whether you can set cells in a spreadsheet to be formatted as text by default I don't know. Maybe try doing as I suggest but import the CSV into the spreadsheet rather than opening it.