General Info on Player Heights

okcyankee · 03-31-2003, 12:33 PM

I used the export player general info to csv file in my fantasy league and when I opened it, the player heights were all dates. Is this something that that is being corrected?

D Love · 03-31-2003, 02:45 PM

Do a search, it's been discussed before. It's Excel automatically reading 6-1 to be June 1. Aside from Markus changing the export to 6'1" or something, the easy way is to simply go to format for that column of cells, pick custom and type in "M-D". It'll show up normal.

However, I do believe that if you reimport with it still showing as June 1, since it's a csv file, the data itself will remain 6-1 and therefore be read by OOTP as 6'1", not June 1. Someone may want to verify that, however. I don't think I had a problem, but I didn't pay attention to height that closely.

Perhaps using an editor other than Excel would work, too.

okcyankee · 03-31-2003, 03:13 PM

Thanks D Love...that is the answer and everything is now ok. Appreciate all the help

03-31-2003, 12:33 PM	#1 (permalink)
okcyankee Minors (Triple A) Join Date: Mar 2002 Location: Oklahoma City, OK Posts: 288 Thanks: 0 Thanked 2x in 2 posts	General Info on Player Heights I used the export player general info to csv file in my fantasy league and when I opened it, the player heights were all dates. Is this something that that is being corrected?

03-31-2003, 03:13 PM	#3 (permalink)
okcyankee Minors (Triple A) Join Date: Mar 2002 Location: Oklahoma City, OK Posts: 288 Thanks: 0 Thanked 2x in 2 posts	Re:Heights Thanks D Love...that is the answer and everything is now ok. Appreciate all the help __________________ CDL - CHICAGO CUBS Great league & great work by the commishes.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

03-31-2003, 02:45 PM	#2 (permalink)
D Love All Star Reserve Join Date: Mar 2002 Location: Queens, NY Posts: 876 Thanks: 0 Thanked 0x in 0 posts	Do a search, it's been discussed before. It's Excel automatically reading 6-1 to be June 1. Aside from Markus changing the export to 6'1" or something, the easy way is to simply go to format for that column of cells, pick custom and type in "M-D". It'll show up normal. However, I do believe that if you reimport with it still showing as June 1, since it's a csv file, the data itself will remain 6-1 and therefore be read by OOTP as 6'1", not June 1. Someone may want to verify that, however. I don't think I had a problem, but I didn't pay attention to height that closely. Perhaps using an editor other than Excel would work, too.