nigelloring
12-06-2005, 10:09 AM
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.
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.