Technical Issues

Why are some LOINC_NUM values converted in Microsoft Excel?

If you open the Loinc.csv file (or any other files in the distribution containing the LOINC_NUM column) in Excel, the application will interpret several of the codes as dates. Excel thinks codes 1-8 through 12-5 are month/day abbreviations, i.e. "8-Jan" and "5-Dec". These codes can be retrieved via a SearchLOINC query (free LOINC login required).

The solution is to create a new Excel workbook file and then import the Loinc.csv, explicity choosing the "CSV file" option.

Import options within Microsoft Excel for Mac,

Knowledge Base

Users’ Guide

Search Syntax