How do I prevent Excel from corrupting my old 400 kHz tag codes?
When directly importing a CSV list that includes PIT tag codes, Excel will corrupt any code consisting entirely of digits except for a single “E”. Excel perceives codes with this mask as a value represented in scientific notation, rather than as a hexadecimal value. The solution to this problem is to rename your CSV list with a “TXT” extension; this will force Excel to import all of the tag codes as text. Refer to the article entitled Protecting PIT Tag Data When Importing Files into Excel on page 5 of the July 1998 PTAGIS Newsletter (Vol. 3, Issue 3). [ Retrieve the July 1998 PTAGIS Newsletter…
