Paul_Christie
New member
- Joined
- Mar 23, 2016
- Messages
- 153
- Reaction score
- 0
- Points
- 0
- Location
- Nottingham, UK
- Website
- www.instantpages.ltd.uk
- Excel Version(s)
- Office 365 Monthly update
I've got a number of csv files organised in a hierarchy of folders. The first field in each record in each file is a date in the form yyyymmdd. There is no field name row at the beginning of the csv files, the data starts with record 1. No problem so far.
If I rename the first column from 'Column1' to 'Date' and then change the data type of the column to Date I get 'error' in that field on each record. If I change the data type to Date and then rename the column it works fine.
It's not a problem but being a bit of a perfectionist I like to be able to explain what's happening, particularly when I have to hand this over to someone who isn't familiar with the Force.
If I rename the first column from 'Column1' to 'Date' and then change the data type of the column to Date I get 'error' in that field on each record. If I change the data type to Date and then rename the column it works fine.
It's not a problem but being a bit of a perfectionist I like to be able to explain what's happening, particularly when I have to hand this over to someone who isn't familiar with the Force.