Jun 16 2017 07:43 AM
Here's an example. I have a long number (it's from a license plate/bar code):
00100018320523710862
Whether I use my bar code software's export-excel function, or PASTE the number directly, here is what I get:
1.00018E+17 |
If I then format the cell as a number, I get:
100018320523710000 |
As you can see, I have lost the '0862' at the end of my number. Any ideas?
Nov 28 2022 04:14 PM
Nov 28 2022 11:18 PM
Jul 24 2023 07:31 AM
Create a new column and format as a text: https://support.microsoft.com/en-gb/office/text-function-20d5ac4d-7b94-49fd-bb38-93d29371225c#:~:tex...)
Ex. If your values are in column L, row 27 then create a new column next to it (column M). And type the following: =TEXT(L27, ##########) and hit Enter.
Note: enter as many hashtags as you need to show all your digits
Aug 02 2023 02:23 AM
Nov 29 2023 06:06 AM
I tried this, but excel is still not pasting the last 2 digits correctly. any suggestions?
Nov 29 2023 08:46 AM
In modern Excel we have an option to disable such behaviour
If copy/paste the value from initial post it returns as
Nov 29 2023 09:36 AM
@Sergei Baklan thank you
Nov 30 2023 04:50 AM
Nov 30 2023 08:46 AM
It shall be on Office 365 subscription at least on Current channel, perhaps on Monthly Enterprise. If you are on semi-annual channel, or not on 365, afraid that functionality is not available.