Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi all! We have been experiencing an issue on site where threads have been missing the latest postings. The platform host Vanilla are working on this issue. A workaround that has been used by some is to navigate back from 1 to 10+ pages to re-sync the thread and this will then show the latest posts. Thanks, Mike.
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel 2007 Problem with dates

  • 05-06-2010 11:35pm
    #1
    FOXFISH1
    Registered Users Posts: 193 ✭✭


    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 ;-) )


Comments

  • #2
    Farcear
    Registered Users, Registered Users 2 Posts: 618 ✭✭✭Farcear


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


  • #3
    FOXFISH1
    Registered Users Posts: 193 ✭✭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.


  • #4
    FOXFISH1
    Registered Users Posts: 193 ✭✭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...


  • #5
    phog
    Registered Users, Registered Users 2 Posts: 24,384 ✭✭✭✭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


Advertisement