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...
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.
Here's is the Link http://espn.go.com/nfl/ standings
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