My number is being formatted into scientific notation! How do I fix it in Excel and then BarTender? Follow

Avatar
Samantha Petro

Question

 I'm pulling data from Excel onto my label, but every time I do, it comes out in scientific notation. How do I fix this?

Answer

With long numbers from an Excel database, sometimes the label will come out like this in scientific notation:

scientific_notation.png

This is happening because Excel is truncating the number.

scientific_notation2.png

 

You can trick Excel into treating this as a number. First delete the contents then change the cell format:

scientific_notation3.png

Paste or type the number into the formula bar, not the cell

scientific_notation4.png

Once you hit enter, you'll notice a warning pop up:

scientific_notation5.png

Excel is now angry that you're storing a number as text, but now you have actual text instead of scientific notation! Go ahead and pull the data back into BarTender and the number should now show up normally.

 

More Information (Optional)

This StackExchange discusses different ways to fix this issue. The one above I've tested as working:

https://superuser.com/questions/413226/why-does-excel-treat-long-numeric-strings-as-scientific-notation-even-after-chan 

Was this article helpful?

0 out of 0 found this helpful

Please sign in to leave a comment.