It’s always a good idea to store ID Numbers as Text, especially as some can start with a leading zero.
The problem though, is that if you convert cells with large numbers to Text it displays it in Scientific Notation. E.g. 8605065397083 display as 8.60507E+12!
This can be one of the most frustrating things in Excel.
The Solution? Use Text-to-Columns instead.
- Highlight the cells (column) you want to convert
- Select Text-To-Columns from the Data Ribbon
- Next, Next to get to the 3rd step of the Wizard
- Select Text under the Column Data Format
- And Finish! 😊