Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Turn off Excel auto formatting

  • 21-04-2005 11:19AM
    #1
    holmsey
    Closed Accounts Posts: 24 ✭


    Does anyone know how to turn off the auto formatting in excel?

    im using a web query that gets the names and odds of horses running at a certain racetrack from the paddy power website and puts them on a spreadsheet. But if a horse has odds of 8/1 for example, excel automatically changes this to 8-Jan (as it auto formats it to a date) which is of no use to me. i need it to be stored as text so i can retrieve it from a java program that im using.


Comments

  • #2
    sceptre
    Registered Users, Registered Users 2 Posts: 19,607 ✭✭✭✭sceptre


    This should be a simple one - either highlight the relevant column by clicking the letter at the top of the sheet or highlight the whole sheet by clicking the blank box at the top left (above 1 and left of A). Then click Format, Cells and select Text. You're done.

    Here's the kicker though - it'll do funny things to any existing data you have in the sheet (given that 14-1 is currently regarded as 14-Jan it'll change that value to the number of days since 1-1-1900 or something). You could export the bare data and reimport it after if this would cause you major issues for your existing data.


  • #3
    Mercury_Tilt
    Closed Accounts Posts: 5,500 ✭✭✭Mercury_Tilt


    This post has been deleted.


Advertisement