Emsi logo
  • Data
    • Glossary
    • FAQ
    • Methodology
    • Release Notes
  • Product
    • How To
  • Blog
Reach Out
← 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

Emsi SOC

When Excel opens a spreadsheet, it does some automatic formatting of the cells within the sheet. If a…

Why Doesn’t Emsi Break Out the Postsecondary Teachers SOC?

When Excel opens a spreadsheet, it does some automatic formatting of the cells within the sheet. If a…

Occupation Earnings Changes in 2019.3 Datarun

When Excel opens a spreadsheet, it does some automatic formatting of the cells within the sheet. If a…

Submit a Question

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

Emsi Logo An affiliate of Strada Education Network Contact
© Copyright 2020 Economic Modeling Specialists, Intl. All Rights Reserved.