Stop Excel from changing large "numbers" (actually text values) to scientific notation.
Prevent Excel from changing large "numbers" (actually text values) to scientific notation.
Thanks very much for your votes. And to those who took the time to fill in the survey, thank you! This is a brief update to let y’all know that we’ve started work on this feature request.
- Urmi [Msft]
They probably just use a leading apostrophe when they enter numeric data as text. That prevents the conversion to scientific notation, but doesn't show in the cells.
they probably have a custom coded database to manage their moneys. or they PAY somebody else to manage the money, and THOSE people have to deal with the headaches.
but i mean, can you imagine if all of Microsoft's services were created using only Microsoft products? their whole company would collapse overnight having to put up with this!
Avin Shum commented
I wonder whether the Microsoft guys' pay slips / credit card number / whatever are using this "scientific" format.
C'mon I'm NOT a scientist. May I use "layman" / "normal person" format as default instead?
Fedor Taiakin commented
It is quite clear that MS is ignoring very legitimate complains about this bug for years. I wonder if there is any good lawyer who would want to make a name on a class-action lawsuit about lost data and productivity against Microsoft. It will be hard to win against giant, but he/she would be famous anyhow.
no way, Jim...i'd sooner die than work for a company that takes decades to decide they are going to work on a problem, then don't fix it for 3 years...
Everyone – I’ve come up with a plan. If we all band together, it might just be crazy enough to work.
I’ve discovered a secret website where all of Microsoft’s open jobs are posted: https://www.linkedin.com/company/microsoft/jobs/. Each of us applies for and obtains a job at Microsoft. Eventually, one of our infiltrators will work their way up through the ranks until they are head of product for excel. At that point, our secret mole will unleash the plan – code name: DESTROY SCIENTIFIC NOTATION. Darkness will lift from the kingdom, and we can all live out our lives in peace and happiness.
I’ve done an analysis using excel, and this should only take 0.2e2 years to work. I believe it's the only way.
Scott McGee commented
You know, it's NICE that Microsoft is updating that default font, because that's always been SUCH a big problem! It's good to see they devote their resources to things that REALLY MATTER, like the default font. And like making sure there's fresh lipstick on the hottest, most trending color, applied to the pig... Important stuff like that!
May the .04E2-th be with you.
It's the unending battle between the unstoppable force of hope, and the immovable Microsoft. On the bright side, they are considering changing the default font, so our numbers as text won't automatically be converted to scientific notation in calibri.
In that case, kudos to you for maintaining a steely resolve in the face of the crushing indifference of the Microsoft Corporation.
Leigh McDonald commented
Not new, Jim, just excited to have new ideas for ways to annoy Microsoft.
you guys must be new around here... i love the enthusiasm though.
I recommend snipping the main post here to grab the "Excel Team" post that states they've begun working on it back in 2018.
Paste that into Excel, and screenshot that.
Leigh McDonald commented
Good idea. I recommend leaving your screen open to this page while you do it, too, since "screenshot" is an option in the feedback panel.
"I recommend you send feedback via Excel>File>Feedback, it is the best method to let the developers know your concern and requirement, and help improving the products.
How do I give feedback on Microsoft Office?
Appreciate your understanding.
I think it would be a good idea for the community to start flooding them with complains on this problem a couple times a day.
top notch excel pain **** post @Anonymous. chef's kiss. i needed that today.
Another day, another large dataset I spent hours manipulating before realizing Excel had made it useless before I even started.
I thought I was done with this project. Turns out I have to start over from scratch. I've been running into this problem periodically for decades now. I can't count the number of hours I've wasted on data made useless by this problem.
It's impossible to remotivate myself after having my work destroyed for no reason like this, so instead I'm going to rant at Microsoft for doing this to me yet again.
The first time this happened to me was nearly 20 years ago. I was working with part numbers and had no idea Microsoft thought it was a good idea to replace all the trailing digits with zeroes. It ended up causing catastrophic problems in our database. It was massively embarrassing for me, and it all but ruined my career opportunities at that company.
At the time, I thought it must have been a bug.
It's happened many more times since then. I've learned to be vigilant, and I've learned all kinds of different tricks to get around this problem that shouldn't exist. I've made the same mistake again and again because no matter how vigilant you are, you eventually let your guard down if Microsoft hasn't screwed you over for a long enough period of time.
My employees have made this mistake and imported bogus data through no fault of their own (and it's not their fault. This is a problem that exists for no reason.). We used to do regular sweeps of our database for part numbers that were inadvertently imported in scientific notation. I've had customers and vendors send me files where they weren't vigilant enough, and I had to go through long email exchanges trying to help them work around this problem so I could get usable data.
I have a short list of recommendations for the people who make Excel:
1. Stop making scientific notation the default option for large numbers. There are exactly six people on the planet who need scientific notation, and I think they’ll be ok if they have to change the format manually.
2. When something gets converted to scientific notation, don’t irreversibly destroy information by replacing all the trailing numbers with zeroes. This causes absolute havoc.
To whoever at Microsoft has managed to roadblock a fix for this problem for 20+ years: Do you have a ticker in your office that counts the number of dollars in productivity you’ve managed to destroy every day? Do you get orgiastic pleasure from seeing the joy fade from a person’s eyes as all the energy they’d been putting into project is suddenly redirected into trying to find the willpower not to slam their keyboard in public?
I hope you get a papercut on your tongue every time you ruin somebody’s work.
How many years will it take?
Feel free to use exponents...
Jay GRANT commented
this is exactly why it is so important that businesses NOT be monopolies (*cough cough* Microsoft *cough*), and that we have other options to fall back on in such scenarios as we become unsatisfied (*cough cough* OpenOffice *cough* Google Sheets *cough*).
sorry, i must be coming down with something ;)