(no subject)

posted by [identity profile] hilarityallen.livejournal.com at 06:41pm on 13/12/2012
Excel does loads of fun things like that. If you have a bunch of user ids that are things like abc23, then you have one like dec23, the latter gets automatically transformed into December 23 {current-year}. So, as you've found, you have to set the column to text when you import it, so it doesn't try to be Too Bloody Clever.
Edited Date: 2012-12-13 06:42 pm (UTC)
[parent entry] [link] [reply]
 

(no subject)

posted by [identity profile] bugshaw.livejournal.com at 07:23pm on 13/12/2012
Ooh, I think there are a bunch of genetic things like that too.
[link] [parent] [reply]
 

(no subject)

posted by [identity profile] pseudomonas.livejournal.com at 11:30pm on 13/12/2012
yeah. I've been bitten by that. Proteins called things like Sept4. Annoyingly, you can't even reverse it cos you can't tell if it used to be Sept4 or Sep4.
[link] [parent] [reply]

September

SunMonTueWedThuFriSat
  1
 
 2
 
 3
 
 4
 
 5
 
 6
 
7
 
 8
 
 9
 
 10
 
 11
 
 12
 
 13
 
14
 
 15
 
 16
 
 17
 
 18
 
 19
 
 20
 
21
1
 22
 
 23
 
 24
 
 25
 
 26
 
 27
 
28
 
 29
 
 30