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


BarTender Content Team


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?


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


This is happening because Excel is truncating the number.



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


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


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


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: 

Do you have feedback or questions on this article? We encourage you to post them on our Community Forums