Two Plus Two Older Archives - Excel help please

Two Plus Two Older Archives (http://archives2.twoplustwo.com/index.php)

- Computer Technical Help (http://archives2.twoplustwo.com/forumdisplay.php?f=46)

- - Excel help please (http://archives2.twoplustwo.com/showthread.php?t=392555)

nigelloring

12-06-2005 10:09 AM

Excel help please

I have a web query in Excel. One of the fields I am getting from the web page is " [some integer] / [some other integer] ".

However, if the field is " 7 / 12 ", Excel automattically converts this to July 12, 2005. How do I stop it doing this? I can't just change the format of the cell since when I refresh the web query, Excel changes it back.

Thanks.

TheWorstPlayer

12-06-2005 10:12 AM

Re: Excel help please

make it "=[some integer]/[some other integer]"
Edit: Just to clarify, "7/12" it reads as a date, "=7/12" it reads as a fraction.

All times are GMT -4. The time now is 04:13 AM.