Forum Discussion

larc91's avatar
larc91
Copper Contributor
Jul 14, 2020

Keeping exact numbers (stop rounding/scientific notation)

I have one column that lists various receipt IDs that include a variety long or short numbers or text (Example: 3666979/JU; 20001010905018546; R00017/2020; 16773...). I just want to keep the exact nu...
excel
Excel on Mac
Formulas and Functions
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Jul 15, 2020

    larc91 

    Try it in this order:

    1. Delete current cell content.

    2. Change number format to "Text".

    3. Type the ID into the cell.

     

phenry1175's avatar
phenry1175
Brass Contributor
Feb 27, 2023
I want Excel to stop doing stupid stuff. Stop converting long numbers into a completely useless and idiotic "scientific notation".

And it is not just for my sake. I have clients who use my software to get automatic reports of devices with all numeric Serial Numbers, ENS, IMEI... Converting these numbers to "scientific notation" is pure idiocy.

Resources