RTO Pro Help File

Excel files using Scientific Notation

Excel files using Scientific Notation

Previous topic Next topic  

Excel files using Scientific Notation

Previous topic Next topic JavaScript is required for the print function Mail us feedback on this topic!  

Comments (...)

This is more of a fix for Excel than RTO Pro. Often when files are opened by Excel it will try to determine the format of a column and format the column accordingly. For fields such as serial number or any other numeric fields, or fields that have some values that are numeric, Excel will decide to treat the entire column as numeric instead of text. The problem with Excel and number is that Excel, in an attempt to save space, will convert a long number such as "1222222244566" to "1.22222E+12", the scientific notation for that number. This "space saving feature" of Excel saves very little screen space and makes the data basically useless unless you are a genius and can do scientific notation in your head.

 

This worked for me in Excel 2010 and newer. Just select the column, right click > Format cells, choose Custom and choose the option that says 0 (second option below General).

 

This will make Excel display the actual numbers instead of scientific quotation.

 

 

Comments (...)