Excel Tip - Prevent Large Numbers from converting to Scientific Notation.


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! 😊










Share on Facebook
Share on Twitter
Please reload

Featured Posts