Forum Discussion
Solved
When I paste a long number, Excel turns it into scientific notation and changes numbers.
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...
after pasting, click on the column, format cells, fraction and ok. That works for me. Keith Kargl
Even though this thread is 7 years old, this may help.
You barcode scanner can be set to include a prefix when you scan. Add the apostrophe as a prefix in your scanner settings and everything will be fine.
You barcode scanner can be set to include a prefix when you scan. Add the apostrophe as a prefix in your scanner settings and everything will be fine.