Forum Discussion
MarkODwyer
Nov 19, 2019Copper Contributor
Prevent conversion to scientific notation
Commonly, I have to paste part identities into excel that are in the format 1234561E1. Excel automatically converts them to scientific notation 123E+07. If I change the format to text it becomes 1234...
SergeiBaklan
Nov 19, 2019Diamond Contributor
You may add your vote to this idea here https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10374741-stop-excel-from-changing-large-numbers-actually?tracking_code=c38d2caa7a6c634cb04685afee5985b5