Excel Tip - How to prevent Excel from converting Large Numbers 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

Excel Tip – Using the Format Painter multiple times

November 20, 2019

1/1
Please reload

Recent Posts