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

holmsey · 21-04-2005 12:22PM #1

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.

Eoin · 21-04-2005 03:38PM

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

BizzyC · 21-04-2005 03:43PM

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.

Wolff · 21-04-2005 03:49PM

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

or try Mrexcel.com

Vgood website

Eoin · 21-04-2005 03:52PM

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.

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

Comments