Excel Tip - Storing ID Numbers as Text
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! 😊