Plus sign at start of data field in Data Query

[Guest]

Hi

For doing my own hockey stats, I'm data querying NHL box scores on Yahoo's site. (For example, http://sports.yahoo.com/nhl/boxscore?gid=2004030908) Every query that I make for the box scores brings down the box score except for the "+/-" header and any +/- stats for individuals who have a +1 or +2 or +3 etc. in that field

Anyone know why fields beginning with "+" are not pasted to the ss?? I've looked through all the settings, can't figure it out

Thanks in advance.

 

[Guest]

You could try this Custom Number Format for the cell you type the number value into
+#,##0_);-#,##0_

This designates that positive numbers will be preceded by a plus and negative numbers would be preceded by a minus
To set it up, go to Format|Cells and click on the Number tab. Click on Custom and type (or copy and paste) the number format on there
Keep in mind that custom number formats are only available in the workbook in which they are created. If you will use it in many workbooks, consider saving it into a template and using that to generate your workbooks

t

----- Relic wrote: ----

Hi

For doing my own hockey stats, I'm data querying NHL box scores on Yahoo's site. (For example, http://sports.yahoo.com/nhl/boxscore?gid=2004030908) Every query that I make for the box scores brings down the box score except for the "+/-" header and any +/- stats for individuals who have a +1 or +2 or +3 etc. in that field

Anyone know why fields beginning with "+" are not pasted to the ss?? I've looked through all the settings, can't figure it out

Thanks in advance.

 

[Guest]

Thnx, tried it but it still won't display any numbers preceded by a + sign in the ss when I refresh the query. The 0's now have a plus sign on them because of the format you suggested. The problem remains the query doesn't pull the numbers down.

 

[Guest]

This thing is taking a while to update, so I'll put this in here again
+#,##0_);-#,##0_);0_
fixes the +0 problem

Is there a reason why you need the query? Are you using this in game? Copy and Paste using HTML format doesn't seem to have this problem. I'm not quite sure what is causing this. Sorry I can't be of more help

tj