User Profile
cchai
Copper Contributor
Joined Jun 01, 2023
User Widgets
Recent Discussions
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 that I cannot control, I already changed the format of the column to text, but it still showing the scientific notation (e.g. 1E+15), so how can I completely stop this annoying scientific notation in text format? And I think it is a bug! I already specify it is a "text" (a TEXT!), not a number, how come excel will still showing the scientific notation (but when I double click into the cell, it shows the original value in digits, so the value is here not missing, **bleep** it!)2KViews0likes3Comments
Recent Blog Articles
No content to show