Scientific notation: remove this "feature" from Excel!

Anonymous
2023-02-24T17:56:39+00:00

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 !

Microsoft 365 and Office | Excel | For business | Windows

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.

0 comments

11 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-02-27T07:56:40+00:00

    Was this answer helpful?

    6 people found this answer helpful.
    0 comments
  2. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2023-02-27T08:05:58+00:00

    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.

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  3. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2023-02-24T20:29:59+00:00

    I am an Excel advanced user

    As advanced user, you know that you can open the little "(Ctrl)" icon that appears after you paste and correct the formatting afterwards. 😉

    Or right-click before you paste and choose the correct paste option.

    https://support.microsoft.com/en-us/office/paste-options-8ea795b0-87cd-46af-9b59-ed4d8b1669ad

    Andreas.

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  4. Anonymous
    2023-02-24T18:01:13+00:00

    Hi admin-sdc,

    Greetings! Thank you for posting to Microsoft Community.

    Format the cell(s) as text before you enter the phone number.

    Or start your input with an apostrophe, the ' sign tells Excel your input is a text and the ' is suppress on screen.

    Best Regards,

    Snow Lu

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  5. Anonymous
    2023-02-25T05:04:27+00:00

    1.Set text format in excel

    2.Copy the data in to notepad

    3.Copy from notepad

    4.Paste to excel

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments