posted by ![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
bugshaw at 12:09pm on 13/12/2012
bugshaw at 12:09pm on 13/12/2012If 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 foryou myself...
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
There are 6 comments on this entry. (Reply.)