← Back to Results

Why Does Excel Sometimes Convert SOC Codes to Dates?

When Excel opens a spreadsheet, it does some automatic formatting of the cells within the sheet. If a cell appears to contain a date, Excel converts the cell to a date. Most of the SOC codes with the prefix “11-” look like dates in the month of November to Excel, so it converts the cells to dates.

This article explains how to use Excel to manually open a CSV downloaded from Analyst such that Excel will not convert “11-” SOCs to dates.

Submit a Question

Let us know what specific questions we can help you with (we may even add your question to our knowledge base).

Related

Submit a Question

Let us know what specific questions we can help you with (we may even add your question to our knowledge base).