Date Function Problem When Importing Tables

[Nikos]

At the moment I am trying to import BOX SCORE statistics from OLD NB
Finals Games and I am getting this DATE error.

In other words, when I paste the table and do text to columns t
seperate each stat for each player -- for example shooting "4-19" i
puts 19-Apr for SOME of the cells, not ALL of them. Even when I selec
all of them and change them to NUMBER some of them still remain wit
that same standard DATE function or whatever causes it to show the dat
instead of allowing me to split the numebrs according to the DASH.

How do I get rid of the dates, so when I paste the table I can le
excel know they are NOT dates, but numbers surrounding a simple das
mark "-"?

Any help would be greatly appreciated.

Heres the link to a sample.

http://webuns.chez.tiscali.fr/finals/1996.htm

Check the bottom two tables with PLAYER STATS.

-Niko

 

[Ron Rosenfeld]

At the moment I am trying to import BOX SCORE statistics from OLD NBA
Finals Games and I am getting this DATE error.

In other words, when I paste the table and do text to columns to
seperate each stat for each player -- for example shooting "4-19" it
puts 19-Apr for SOME of the cells, not ALL of them. Even when I select
all of them and change them to NUMBER some of them still remain with
that same standard DATE function or whatever causes it to show the date
instead of allowing me to split the numebrs according to the DASH.

How do I get rid of the dates, so when I paste the table I can let
excel know they are NOT dates, but numbers surrounding a simple dash
mark "-"?

Any help would be greatly appreciated.

Heres the link to a sample.

http://webuns.chez.tiscali.fr/finals/1996.htm

Check the bottom two tables with PLAYER STATS.

When I checked that link, I didn't see dashes in the lower two tables.
However, to do what you want, import those columns as TEXT.


--ron

 

[Nikos]

Thanks!

It seems to work when I import as UNICODE Text.

Why is it when I did a simple paste though and tried to reformat th
numbers with dashes that some of them stayed as dates and wouldn
change formats (out of curiosity)

 

[Ron Rosenfeld]

Why is it when I did a simple paste though and tried to reformat the
numbers with dashes that some of them stayed as dates and wouldnt
change formats (out of curiosity)?

Most likely the numbers with included dashes, that got imported that way, were
being interpreted as TEXT and not as DATES.


--ron