Hi guys,

I found a source that would be of tremendous value to me if not for this
little bug. The halfs or .5's is expressed using the little symbol "½"
(located on "Shift + Paragraph" key on my notebook) instead of figures. Now,
all the cells containing this little character is automatically formatted as
text and those without it is formatted as numbers when I paste or web query
this source. I would really appreciate any help in making Excel format the
"½" (little bugger) as .5 so I can use this source for calculations. Just to
clarify, the data could look like this:

4
2
3½
7
9½
8

So it's a mixture of plain numbers and this symbol and there's no other
decimals involved than the halfs.

Regards
Mitch