HawaiianShirts
New Member
- Joined
- Jul 19, 2014
- Messages
- 15
- Office Version
- 365
- Platform
- Windows
The Format Cells "Date" settings are behaving... strangely.
I regularly pull in data from a reporting system via csv files. The source formatting is always the same, but Excel seems to be seeing something that I am not. When I copy the csv data from the source file to the .xlsx spreadsheet, I paste values. The various "Date" columns are already formatted to mm/dd/yyyy, but sometimes they lose that and revert to a serial number. So I select the column, open the Format Cells box, and select the "Date" category so I can set it back to the mm/dd/yyyy that I want.
In any other spreadsheet, this works without any problem. In the one that I paste my csv data into, the "Locale" field in that Format Cells box seems to pick a different region at random. Today, for example, the "Locale" for one worksheet defaulted to Greek, the locale for another worksheet defaulted to Portuguese, and another defaulted to Chinese.
I had a similar problem a few months ago where a currency column's "Locale" setting kept defaulting to Zimbabwe.
Anybody have any idea what might be causing this?
I regularly pull in data from a reporting system via csv files. The source formatting is always the same, but Excel seems to be seeing something that I am not. When I copy the csv data from the source file to the .xlsx spreadsheet, I paste values. The various "Date" columns are already formatted to mm/dd/yyyy, but sometimes they lose that and revert to a serial number. So I select the column, open the Format Cells box, and select the "Date" category so I can set it back to the mm/dd/yyyy that I want.
In any other spreadsheet, this works without any problem. In the one that I paste my csv data into, the "Locale" field in that Format Cells box seems to pick a different region at random. Today, for example, the "Locale" for one worksheet defaulted to Greek, the locale for another worksheet defaulted to Portuguese, and another defaulted to Chinese.
I had a similar problem a few months ago where a currency column's "Locale" setting kept defaulting to Zimbabwe.
Anybody have any idea what might be causing this?
