Forum Discussion
cchai
Jun 02, 2023Copper Contributor
The annoying excel scientific notation
I have a column which is the supplier item code, it contains text or a long barcode (so it is not pure long "number" barcode), e.g. ABC123456 1000000000000000 The data are from some source th...
Cangkir
Jun 02, 2023Brass Contributor
In the formula bar, do they show as original number? for example: 1000000000000000 instead of 1E+15.