Excel 2007 Problem with dates

FOXFISH1

Hi Folks,
I've imported some soccer data into an excel 2007 spreadsheet.
The problem i'm having is that anywhere there is a match score of,
let's say, 2-2, it appears on the sheet as 2nd feb.
I've been experimenting with the cell formatting and tried a few different things but can't find an easy way to solve this problem,
any help appreciated......(world cup getting close ;-) )

Farcear

Press Ctrl+1 on the cell and then set category to "text".

FOXFISH1

Thx for reply Farcear,
Yes this works fine if i format the cells as text and type the scores into the cells.

However, even when i pre-format the destination cells as text, and then import the data from the website into those cells, it still pastes in as dates instead of match scores.

FOXFISH1

ok guys...just found a solution,

When importing the data, on the 'New Web Query' page select 'options' on the top right-hand side, and then check the 'Disable date recognition' box.
Then import the data...

phog

FOXFISH1 wrote: »

ok guys...just found a solution,

When importing the data, on the 'New Web Query' page select 'options' on the top right-hand side, and then check the 'Disable date recognition' box.
Then import the data...

Thanks for that, must remember when keeping track of the H/Cup results next year.:D