Technical Issues
This section last updated: 2022-07-27 (2 years ago)
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.
Knowledge Base
- Home
- License
- LOINC Release Notes
- Release Notes Archive
- LOINC Release Notes, February 2024 (Version 2.77)
- LOINC Release Notes, September 2023 (Version 2.76)
- LOINC Release Notes, August 2023 (Version 2.75)
- LOINC Release Notes, February 2023 (Version 2.74)
- LOINC Release Notes, August 2022 (Version 2.73)
- LOINC Release Notes, February 2022 (Version 2.72)
- LOINC Release Notes, August 2021 (Version 2.71)
- LOINC Release Notes, June 2021 (Version 2.70)
- LOINC Release Notes, December 2020 (Version 2.69)
- LOINC Release Notes, June 2020 (Version 2.68) & earlier
- Versioning
- Enriched Linkages between LOINC terms and LOINC Parts
- Abbreviations and acronyms used in LOINC
- Search API
Users’ Guide
- 1 – Introduction
- 2 – Major Parts of a LOINC term
- 3 – Special cases
- 4 – Clinical observations and measures
- 5 – Claims attachments
- 6 – Document Ontology
- 7 – Panels (Batteries)
- 8 – Evolving principles for naming collections
- 9 – Additional content in the LOINC distribution
- 10 – Standardized assessment measures
- 11 – Editorial policies and procedures
- 12 – Recommendations for best practices in using and mapping to LOINC
- A – LOINC Database Structure
- B – Classes
- C – Calculating Mod 10 Check Digits
- D – Procedure for Submitting Additions or Changes to LOINC
- E – Examples for LOINC Property Matching
- G – LOINC Technical Briefs
- D-Dimer Revisions in LOINC
- Choosing the Correct LOINC for Estimated Glomerular Filtration Rate
- Inducible Clindamycin Resistance in Staphylococcus and Streptococcus
- KIR Gene Family
- Oxygen Saturation and LOINC
- Nomenclature of Salmonella Species, Subspecies, and Serovars
- Segmented Neutrophils Versus Polymorphonuclear WBC
- Vitamin D
- Free Thyroxine Index Variants
- Streptococcus pneumoniae serotype nomenclature
- Non-linear Numerical Values “Binned” to Ordinal or Range
- H – LOINC Committee
- LOINC/RSNA Radiology Playbook User Guide
Search Syntax
RELMA
- Overview
- User Preferences
- Searching in RELMA
- Keyword Spell Check
- Term File Operations
- Import Local Terms
- Mapping Local Terms to LOINC
- HIPAA Claims Attachments
- Lab Auto Mapper
- Community Mapping Repository
- Requesting a new LOINC