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

How do I turn off excel auto formatting????

Options
  • 21-04-2005 12:22pm
    #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

  • Options
    #2
    Eoin
    Registered Users Posts: 21,257 ✭✭✭✭Eoin


    holmsey wrote:
    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.

    Hi, try putting each value in double quotes ("8/1") - I don't know if this will resolve your particular problem, but I have used it for dealing with values with Commas in them (screwing up CSV files), and for values with line feeds etc.

    Eoin


  • Options
    #3
    BizzyC
    Registered Users Posts: 3,012 ✭✭✭BizzyC


    holmsey wrote:
    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.

    Select the cells , right click, open format cells, and under the number tab set the cell type to text. Then it wont change a thing you enter.


  • Options
    #4
    Wolff
    Registered Users Posts: 1,187 ✭✭✭Wolff


    if you format the spreadsheet to text first then copy down - should work for you

    or try Mrexcel.com

    Vgood website


  • Options
    #5
    Eoin
    Registered Users Posts: 21,257 ✭✭✭✭Eoin


    BizzyC wrote:
    Select the cells , right click, open format cells, and under the number tab set the cell type to text. Then it wont change a thing you enter.

    How are you putting the values into the spreadsheet in the first place? If you are using some type of Excel API, then you might have control over the cell options, and you can change the settings like BizzyC has mentioned. If not, then just try quoting the values.


Advertisement