2012-12-13

bugshaw: (BugCount)
2012-12-13 12:09 pm

Excel fun!

If you have a list of organisation codes in a csv file that you distribute, and they go in a nice alphabetical order like this:
8A001
8A003
...
8DY95
8DY99
8E004
8E008
8E017

then when you open it in Excel (which seems a fairly straightforward thing to do) the codes come out like this:
8A001
8A003
...
8DY95
8DY99
80000
800000000
800000000000000000

Let me fix that for you myself...