This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Please allow users to paste phone numbers, without converting it to scientific notation. It's a shame.
Who need it? How many years people should "hack" Excel to paste numbers?
See this SuperUser post to all the pain you do to users just for a simple Ctrl+V.
I tried to format cells as text, I removed all cells, selected all cells, put Formatting, Number=>Text. After that pasted.
I saw my big numbers as bellow in ... scientific format... I hate now the scientific format.
tried it before the paste however that does not help, tried after the paste, does not help.
This is a bug: the formatted as text column should not convert anything to anything!
paste this one 1837503030608800000
If I convert this as a number, it will remove all the spaces, I don't want my spaces be removed! I want my text as it is initially.
I never in my live needed the scientific notation, however I work in IT all my live.
The Excel is kidding on itself
old complaints, https://superuser.com/a/413277/465922
any correction from MS for years !
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
For what reason?
If I counted correctly, then at least 5 users from this forum told you where you made the mistake and I also explained in detail why that was the case.
If you don't listen to us, further conversation is pointless.
Andreas.