Sunday, September 16, 2012

yogi_Maintain Format 1-1-0 (win-lose-tie) Not Date 1/1/2000 In Data Imported From Website

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #753   Sep 16, 2012     www.energyefficientbuild.com.

user gregpaves said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/Jct3qZSLksA)
Stats, not Dates Help... maintain format 1-1-0 (win-lose-tie) not date 1/1/2000 
Hello all,I'm pretty good at spreadsheets and the like but this ones got me flustered...
I'm importing an html table from ESPN  for a NFL POOL.  
the Table come in with a format of wins-loses-ties i.e. 1-0-0 or 1-1-0
I have the table format set to plain text Yet, google still writes them as a date.
so the data changes each week from 1-1-0 to 1/1/2000 or 35620

NFC NORTH W L T PCT HOME ROAD DIV CONF
Detroit 1 0 0 1 1-0-0   0-0-0         0-0-0   1-0-0
Minnesota 1 0 0 1 1-0-0  0-0-0  0-0-0  0-0-0
Green Bay 1 1 0 0.5 1/1/2000 0-0-0         1-0-0         1/1/2000
Chicago 1 1 0 0.5 1-0-0         0-1-0  0-1-0  0-1

Any advise or fixes???
Because this is an =IMPORTHTML(...) I can't modify the cells with a formula
----------------------------------------------------------------------------------
following is a solution to the problem


No comments:

Post a Comment