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

Featured Posts
Posts Are Coming Soon
Stay tuned...
Recent Posts
Archive
Search By Tags

Training Offices:

Johannesburg

106 Johan Avenue, Sandton

Durban

1 Tamarind Close, Umhlanga

Pietermaritzburg

400 Old Howick Road, Hilton

Corporate Onsite Training Available Countrywide

  • Summit Solutions Excel Training
  • Summit Solutions Excel Training
  • Summit Solutions Excel Training

Tel: 086 167 3923

Email: info@summitsolutions.co.za 

Head Office: Hilton Quarry Office Park, 400 Old Howick Road, Hilton.

2020 | Copyright | Summit Solutions