Excel reports and library barcodes
Have you ever opened an ILS report file and seen some data like the mess shown here? I think we all know that valid item and patron barcodes are longer than these, and that they don't have "E+13" in them.
Of course you may not have ever seen that, because SCLS staff do try to clean up such things for you. But sooner or later we may miss a spot. More likely, you'll get this kind of result on your own while playing in whatever kind of do-it-yourself reports tools get added onto ILS services over time.
No worries, it's just Excel being Excel. It sees a number with lots of digits (twelve or more), and it decides to show some initiative and help you out. It automatically converts those long numbers into a "scientfic notation" format. Because that's better, right?
Yeah... not so much, really. Luckily this is easy to correct:
1. Select the columns or range of cells you want to fix.
2. Right click inside that area and choose "Format Cells..."
3. Choose the "Number" format category.
4. Reduce the value of the "Decimal places:" field to zero.
5. Click OK.
Wallah! There's your barcodes, all shiny and new like Excel never made hamburger out of them at all.