Import - blank cell problem.

[Domingos]

When I try to import :

http://www.theahl.com/AHLStatistics0405/albany.html

In statistics +/- when number is +3 or any oder + i have blank cell.
When number is 0 or -1 it work okej. What can I do ?

Domnik

 

[JulieD]

Hi Domnik

how are you "importing" it .. and what version of excel are you using?

i did it via a web query (data / get external data / new web query) and it
came in fine for me (ver 2003)

Cheers
JulieD

 

[Gord Dibben]

Domnik

How are you "importing" the stats.

If I just copy and paste to Excel I see no problem.

BTW there is only one player on the plus side anyway.

I think you should pick a different team for your pool<g>


Gord Dibben Excel MVP

 

[Rob van Gelder]

It's possible that you have a custom number format which looks similar to:
;-0;0

Try resetting it to General