Solution to the height import problem when using Excel

[Malleus Dei]

Statfreak has found a way around the height import problem when using Excel:

"It's easy to get the correct heights to import back into the game. Just need to set the format for the column to m-dd. I also do a quick if...then statement to change the 6/1/2000 date to text 6-0. Otherwise everyone that was 6-0 would be 6-1."

"The actual formula I use (off to the right of the data, in an empty column/cell) is...

=if(m2<>36678,m2,"6-0")

Copy that down for all players.

highlight the results, copy and paste values in column M.

highlight column M, select format ---> cells ---> custom and type in m-dd. All the data in column M will now appear as 6-01 or 6-0 or 5-10, etc...

Takes me about 2 minutes to complete the whole process.

36678 is the numeric equivalent of the date 6/1/2000."

[dougaiton]

Great stuff guys. This should be stickied, because CSV editing has a ton of uses!